Security issues.

[Guest]

Oaky I walked through the security wizard and have locked myself out of my
database to be able to change data. I don't know how to log in as an admin
and change my user permissions. Please help.

 

[Joan Wild]

You don't mention what version, but likely the wizard created a desktop
shortcut that you can use to launch the secure mdb.

 

[Guest]

2000 sorry. It did create the shortcut but for some reason it won't let me
put it on my network it will only let me use it on my pc.???? Thanks so much!

 

[Joan Wild]

You don't want to put the shortcut on the network.

You would put the mdb, and the mdw you used to secure it with on the
network.

You should actually split the database into frontend (all objects except
tables)/backend (just the tables). Put the backend on the network, and give
a copy of the frontend to each user.

Since you've secured it, you should split manually and not use the splitter
wizard as that will unsecure the backend.

Then you'd create a shortcut for each user on their PC with a target of
"path to msaccess.exe" "path to frontend" /wrkgrp "path to secure mdw on
network"

If everyone has installed Access and the frontend to the same location, you
can copy the shortcut to each user; otherwise you'll need to modify the
shortcut for each user.