?
Solved

Access error: Cannot open the Microsoft Access database engine workgroup information file

Posted on 2012-08-23
7
Medium Priority
?
4,727 Views
Last Modified: 2012-09-21
This is a office 2010 access using a front end database and I can connect as administrator but not as a particular user, so far I've:
1.done a repair on access.
2. copied the system.mdw file form the administrator to the users's directory
3.  Made the user a local administrator

All to no avail, please advise.
Thanks
Larry
0
Comment
Question by:lcoolidg
  • 4
  • 2
7 Comments
 
LVL 13

Expert Comment

by:Norm Dickinson
ID: 38327887
Make sure the user has the proper rights on the server location where the database resides. Perhaps test the ability to create a text file and delete it or copy a small file to the location.
0
 

Author Comment

by:lcoolidg
ID: 38327923
User can create file and delte it where database is located.
LC
0
 
LVL 13

Expert Comment

by:Norm Dickinson
ID: 38328535
That should narrow it down to the privileges internal to the database. You may have to specifically set the user up in the database security or check the permissions there if the user is already set up. Are there other users who can access the database, and only one (or some) who can't? If that's the case then maybe you can remove the user from the database security and recreate them. Be careful when playing with database security settings, however, as it is sometimes easy to make changes but hard to get things to work correctly after. Many a database administrator has locked themselves out of a database after enabling security, so make a good backup of the database (and test the ability to restore the backup) before making changes.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 28

Expert Comment

by:burrcm
ID: 38328737
This is not an Access 2010 file - accdb - as there is no user security in this format, so it is an mdb - 2003 or earlier. If as it appears, user security was set up when this db was created, you will need to find the original mdw file which was associated with the file. Once you point the database at this file, you will be able to open it (provided you know the password), then convert to accdb if you wish.

You can open the file using the correct mdw file with this string -

 "C:\Program Files\Microsoft Office\OFFICExx\MSACCESS.EXE" "C:\Your directory\YourDb.mdb" /WRKGRP "C:\A directory\Your Workgroup.mdw"

(Make the appropriate substitutions)

Chris B
0
 

Author Comment

by:lcoolidg
ID: 38333095
I used the known good .mdw file that works for everybody else, his was a few k different size, and access would not open for problem user.
I loged in as administrator to the xp system and opened the access 2003 database with access 2010 and reset the problem user password.
I then closed access and re-launched and could login as problem user.
I exited windows and loged in as problem user and get the same error when trying to launch access which comes up before the access login dialog box.
I'm going to redo their windows profile after this weekends full backup to see if its a currupt windows profile.

LC
0
 

Accepted Solution

by:
lcoolidg earned 0 total points
ID: 38404382
I ended up deleting profile on client and server and that took care of it.  Thanks for the suggestions.
Closing.

Larry Coolidge
0
 

Author Closing Comment

by:lcoolidg
ID: 38421064
Solved the problem, others suggestions did not work.
LC
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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 …
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

850 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