Solved

Open MS Access with missing Workgroup file

Posted on 2009-05-05
10
325 Views
Last Modified: 2013-11-25
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
0
Comment
Question by:nutnut
  • 4
  • 3
  • 2
10 Comments
 
LVL 21

Accepted Solution

by:
JBlond earned 500 total points
ID: 24304503
Have you already tried to create a new database and then point Access to the old database to import the data into the new database?
0
 

Author Comment

by:nutnut
ID: 24304532
Yes and it asks me to create an index...which I cannot do as I cannot get into it....catch 22!
0
 
LVL 21

Expert Comment

by:JBlond
ID: 24304597
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?!
0
 

Author Comment

by:nutnut
ID: 24304813
I do not have anything accept the mdb file
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 21

Expert Comment

by:JBlond
ID: 24311723
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.
0
 

Author Comment

by:nutnut
ID: 24313758
Thanks for all your help so far
0
 
LVL 57
ID: 24314600
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.
0
 

Author Comment

by:nutnut
ID: 24323359
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
0
 
LVL 57
ID: 24324736
 The DB was secured.  You need to use the workgroup file it was secured with.
JimD.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
When we talk about DevOps toolchains, I sometimes wonder how many people really get what we’re talking about. I don’t know if it’s just semantics or tone or something else, but sometimes I think it just sounds like buzzword sausage. So it’s always …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now