Security

Ask something
Discussion Locked

Access 2000 - Please Help!

0 helpful
7 replies

by ideafixer

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I assigned a user group for a database I designed in Access 2000. The application was reinstalled. I set an Administrator login that had all rights to edit my database. When the reinstall occured (I did not do the reinstall) my administrative user name no longer exists.

After the history:

Now, I cannot get into access at all. When I launch Access a login screen appears and I have no accurate password to enter. This occurs even when I try to create a new database. How can I reset thesecurity so I can get into Access?

Please advise,

Robert

7 replies

by mackem

You must logon as administrator and then take ownership of the access folder in explorer using the security tab in properties. if this doesn't work you may have to uninstal then reinstal access.
Check also to see if any new workgroup admin groups have been created.

by ideafixer

I cannot get into the database at all. I really don't need the database at all I just need to get into Access. Is there any way to just delete all of the security settings?

by mackem

You don't have to Open Access to take ownership, just the folder in Explorer. You will find it in C:\program files\microsoft office\office\msaccess. If there is no security tab, which you will only have with NTFS, if you are using Windows NT then look for Wrkgadm.mdw which you will find in system32 in NT or system in wondows 9x. this gives you the oppertunity to create new security for access or to join an existing security file.
first look at the existing security file, which shows on the dialogue box. If you don't recognize the file then create a new file which will match your current login, log out of windows and back in. you should now be able to open Access. If you still cant open the database, then create a blank database, andimport all of the tables forms queries etc from the original. this will give you ownership of the database.
Hope this works for you.

by robbinsr

You can obtain programs to restore passwords or reviel passwords for Microsoft Office Products on Downloads.com. hope it helps.

This discussion is closed to new replies.