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

Posted on 2012-08-23
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.
Question by:lcoolidg
    LVL 13

    Expert Comment

    by:Norm Dickinson
    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.

    Author Comment

    User can create file and delte it where database is located.
    LVL 13

    Expert Comment

    by:Norm Dickinson
    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.
    LVL 28

    Expert Comment

    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

    Author Comment

    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.


    Accepted Solution

    I ended up deleting profile on client and server and that took care of it.  Thanks for the suggestions.

    Larry Coolidge

    Author Closing Comment

    Solved the problem, others suggestions did not work.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    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…

    758 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

    12 Experts available now in Live!

    Get 1:1 Help Now