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.

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

Show quoteHide quote

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!

Show quoteHide quote

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.


Show quoteHide quote

self-signing certificate
Problem with References
Import to bypass security
RE: ade to adp - utility available to help protect source code
Read only for staff
Lost mdw files
Clear Password through VBA
Open Access from an Access program that is currently running
Password , limit the number of trys, is it possible ???
workgroup information file & passwords