Stripping Security from a DB

  • Thread starter Thread starter Grumpy Aero Guy
  • Start date Start date
G

Grumpy Aero Guy

What is the procedure for removing all security from a database assuming I
am the admin and have those privilages.

I have become the Access "go-to" person at work, and, believe it or not,
someone approached me with an Access 95!!!!!! database that they finally
decided to upgrade to 2000 (geeez)

I am seeing an issue that I believe would go away if I could strip all of
the security out of the 95 DB.

Any ideas?
 
Login as a member of the Admins Group, or the owner of the mdb.

Grant full permissions to every object (don't forget the database object) to
the Users Group. Close Access.

Use the workgroup administrator to make sure you are joined to the standard
system.mdw that ships with Access.

Open Access and create a new mdb (you should get no login prompt).

Import everything from your mdb. This new mdb will be unsecured.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need Password Hack for Earlier Version Of Access DB 10
Security ? 1
security issue with DB 3
Problems converting old DB to Access 2007 1
Security Wizard Problem 1
Create a new DB by importing from another DB 1
Splitting a DB 7
Convert Access 2003 with security to Access 2007 2

Back
Top