Home All Groups Group Topic Archive Search About
Author
2 Oct 2006 3:00 PM
Alliance15
This will probably sound like a complete newbie question, but...

I secured my database with the user-level wizard, and it was running
smoothly.  Then, dumb me, deleted the desktop icon that allowed entry into
the database. How do I replace the desktop icon to start the database with
the user ID/password again?  I keep looking, but have not found anything that
can help.

I have tried creating a new icon and targetted both the Database.mdb and the
Secured.mdw, but neither will allow me entry into the database.

Thanks!

Author
2 Oct 2006 10:10 PM
Joan Wild
Alliance15 wrote:
> This will probably sound like a complete newbie question, but...
>
> I secured my database with the user-level wizard, and it was running
> smoothly.  Then, dumb me, deleted the desktop icon that allowed entry
> into the database. How do I replace the desktop icon to start the
> database with the user ID/password again?  I keep looking, but have
> not found anything that can help.
>
> I have tried creating a new icon and targetted both the Database.mdb
> and the Secured.mdw, but neither will allow me entry into the
> database.

That's close.  Start with a target that points to the mdb.  Right click this
target and edit the Target line.  It'll currently have
"path to Database.mdb"

Edit it to have "path to msaccess.exe" at the front of it and
/wrkgrp "path to Secured.mdw" at the end of it.  There's a space between the
paths.



--
Joan Wild
Microsoft Access MVP
Author
3 Oct 2006 1:27 PM
Alliance15
Show quote Hide quote
"Joan Wild" wrote:

> Alliance15 wrote:
> > This will probably sound like a complete newbie question, but...
> >
> > I secured my database with the user-level wizard, and it was running
> > smoothly.  Then, dumb me, deleted the desktop icon that allowed entry
> > into the database. How do I replace the desktop icon to start the
> > database with the user ID/password again?  I keep looking, but have
> > not found anything that can help.
> >
> > I have tried creating a new icon and targetted both the Database.mdb
> > and the Secured.mdw, but neither will allow me entry into the
> > database.
>
> That's close.  Start with a target that points to the mdb.  Right click this
> target and edit the Target line.  It'll currently have
> "path to Database.mdb"
>
> Edit it to have "path to msaccess.exe" at the front of it and
> /wrkgrp "path to Secured.mdw" at the end of it.  There's a space between the
> paths.
>
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Thanks, but I think I am doing something wrong.  I thought I had done what you instructed, but it only opens the Database.mdb and the switchboard won't start.  Perhaps if you type out an example using something like "C:\My Documents\..."?

Thanks again!


Show quoteHide quote
>
Author
3 Oct 2006 2:44 PM
Joan Wild
Alliance15 wrote:
> "Joan Wild" wrote:
>
>>
>> Thanks, but I think I am doing something wrong.  I thought I had
>> done what you instructed, but it only opens the Database.mdb and the
>> switchboard won't start.  Perhaps if you type out an example using
>> something like "C:\My Documents\..."?

If the database.mdb opens then the shortcut is working fine.  But here's a
sample target:
"C:\Program Files\Microsoft Office\Office11\msaccess.exe" "C:\Documents and
Settings\wsmith\My Documents\Database.mdb" /wrkgrp "c:\Documents and
Settings\wsmith\My Documents\secure.mdw"

That's all on one line.

As I said, I don't think there's a problem with your target or the mdb
wouldn't open at all.  If you want the switchboard to open on startup, open
the mdb and go to Tools, Startup, and under Display Form choose your
switchboard form.

--
Joan Wild
Microsoft Access MVP