Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

All permissions revoked. Recover?

Status
Not open for further replies.

cthaxter

Programmer
Aug 2, 2001
71
US
In setting permissions and accounts, I assumed the Admins group had all the administrative permissions. It didn't; the Users group had those.

Instead of setting up all the users first and then revoking permissions from Users, I first revoked permissions from Users. I only did this for tables. Now, nobody can open tables.

Does anyone know how to remove security from a Microsoft Access 2000 database, without having any permissions to it? Or, alternatively, how to access the database somehow so I can recreate the structure? Luckily, there's no data in it; I'm just trying to recover the structure.

Hoping against hope,

Christopher
 
Create a new database and import the information into it. Be careful not to import the permissions. Do not set up any permissions in the new database until you get the data first.

Reg
 
I revoked ALL the permissions to the tables, including read permissions. Is there any way to recover them? Importing them is impossible, unless you know of some way to import a table you don't have permissions to. Any ideas?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top