Lost Desktop Icon

[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!

 

[Joan Wild]

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.

 

[Alliance15]

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!

 

[Joan Wild]

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.