Open MS Access with missing Workgroup file
I have an old MS Access db, I have the password but do not have the workgroup file.
How should i open it as I need to get to the data in the tables.
Thanks
How should i open it as I need to get to the data in the tables.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
From http://support.microsoft.com/kb/305542
If you establish Access security in a database, Microsoft recommends that you store a backup copy of the workgroup information file in a safe location. If the file is lost or damaged, the only way to recover the workgroup information file quickly is to restore the file from a backup copy. If you do not have a backup copy, you must re-create the User and Group Accounts with the same Personal IDs that were originally assigned. If the new workgroup information file is not created exactly as the original file, you will not be able to open the database with the workgroup file.
Maybe you can recover the file from the original location?!
If you establish Access security in a database, Microsoft recommends that you store a backup copy of the workgroup information file in a safe location. If the file is lost or damaged, the only way to recover the workgroup information file quickly is to restore the file from a backup copy. If you do not have a backup copy, you must re-create the User and Group Accounts with the same Personal IDs that were originally assigned. If the new workgroup information file is not created exactly as the original file, you will not be able to open the database with the workgroup file.
Maybe you can recover the file from the original location?!
ASKER
I do not have anything accept the mdb file
Please click on 'Request Attention' and request to add this question to the MS Access-zone. Maybe one of the experts there knows a solution.
I'm not that experienced with Access to say for sure if it's possible to recover the data or not.
I'm not that experienced with Access to say for sure if it's possible to recover the data or not.
ASKER
Thanks for all your help so far
If you don't have the workgroup file that the DB was secured with, nor the information it was created with (so you can create another), then I'm afraid we can't help you here as the EE member agreement does not allow assists in cracking product security.
A quick internet search will give you options on tools you can use to get at the data.
I am assuming that you have tried to open the DB and getting some type of permission denied error. If not, try that. If your getting some other type of error, then the DB may be corrupt and you'll need a different copy from backup or need to use a recovery service (again, an Internet search will turn up many).
JimD.
A quick internet search will give you options on tools you can use to get at the data.
I am assuming that you have tried to open the DB and getting some type of permission denied error. If not, try that. If your getting some other type of error, then the DB may be corrupt and you'll need a different copy from backup or need to use a recovery service (again, an Internet search will turn up many).
JimD.
ASKER
Hi,
I am getting the error
"The Current user account doesn't have permissinon to convert or enable this database"
It is a db create in MS Access 97 and I am trying to open on MS access 2007
Any ideas on what is wrong please
I am getting the error
"The Current user account doesn't have permissinon to convert or enable this database"
It is a db create in MS Access 97 and I am trying to open on MS access 2007
Any ideas on what is wrong please
The DB was secured. You need to use the workgroup file it was secured with.
JimD.
JimD.
ASKER