I have a similar problem to a previous post.
I had to unexpectedly reformat my server. I when reinstalled access I could
not administrator access to the databases.
I looked my backup and couldn't find a copy of the previous security files.
Is there a way I can recreate them?
I know my password and 4 digit security code.
No backups on a server? If you can find a workgroup file (even if it's an older one), you should be able to get into the
database. You'd have to recreate users and groups perhaps, but that's better than rebuilding the database.
If you can't find a workgroup file, perhaps you could re-create it. Here's a copy/paste from the Access online help
topic "Create, Join, or fix workgroup information files":
----------- Start -------------
If a workgroup information file becomes damaged or has been deleted, and a backup copy isn't available, you can
re-create the workgroup information file if you have the exact case-sensitive information that you used to create the
file and define the accounts and groups in the file originally.
Create a new workgroup information file, making sure to enter the exact case-sensitive name, company name, and workgroup
ID (WID) that you used to create the original file. Failure to re-enter the exact entries used to create the original
file will create an invalid Admins group.
Re-create any group accounts, making sure to enter the exact case-sensitive group name and personal ID (PID) for each
group.
Re-create each user account, making sure to enter the exact case-sensitive user name and PID for each user.
How?
If you saved the new workgroup information file to a new name or location in step 1, tell other users in the workgroup
----------------- End -------------------
How can I get back in to the database?
Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com