How do I recover personal ID (PID) numbers in a secured access db

[Guest]

I am the administrator of an Access dbase. I've lost the file of Personal ID
(PID) numbers. I have the 'One-Step Security Wizard Report' and I know the
user passwords. Is it possible to do anything?

 

[IanOxon via AccessMonster.com]

There is cracking software to get PIDs but it might be simpler to recreate
the database. Here's what you can do.

1. Open the db as normal.
2. Create a new user account and, having made a note of the PID and password,
make that user a member of the admins group and give it explicit full
permissions for all database objects.
3. Close access and create an new mdw file.
4. Open access using this workgroup information file. Skip opening a
database file.
5. Go to Security > Users & Accounts and recreate the new user and add it to
the Admins group
6. Change the default admins user password.
7. Exit access and then reopen it using the new User account.
8. Create a new database and import all the database objects from the
original database file.
9. Recreate all other User and Group accounts icluding passwords using
Security > Users & Accounts.
10. Recreate group and user account permissions for all database objects.

The only downside to this is that the owner of all database objects and the
database will be the new account. Changing the ownership of the objects is
easy but to change the owner of the file you'd have to recreate again using
the appropriate user account.

I hope this helps.


Ian