For some reason, I have put in place security restrictions (even though I
don't need them) on my access database accidently.  Even the Admin user has
no permissions.  So I am stuck.  I can open the database, but nothing else.

Depends on what version, and what you actually did.

If a recent version (2002 or 2003) and you ran the security wizard, it
created a backup of your unsecure mdb.  It is in the same folder as your
mdb, but it has a bak extension - just rename it to have a mdb extension and
you should be fine.

Also ensure that you are joined by default to the standard system.mdw
workgroup file that ships with Access - you can check this in Tools,
Security, Workgroup Administrator.  You should have no login prompt while
using this workgroup file.



Show quoteHide quote

MDW locks, cant add/modify users
Security Problem with Adobe 7.0
problem with a batch file wkgrp parameter
Security nightmare
Make mdb Read Only in code?
Default CurrentUser when not opening form
shortcut just to access
Removing Security from One MDB
How do I retrieve a User PID
Warning message