We help IT Professionals succeed at work.

Access MDW File problem

siva_iaf asked
Medium Priority
Last Modified: 2013-11-28
All Access fies that I create or receive from other require me to Logon with user name and password (using Mdw file). In my earlier project I was working with access files that were protected but now I dont need (MDW)  them any more.
How do I remove this MDW problem from my access files.. I want to open files straight away.
Watch Question

In your Maicrosoft Office folder where MSACCESS.EXE is there is a Workgroup Administrator, this will allow you to join the deault MDW file. You will then need to remove the restrictions you have setup in the database(s). The simplest way to do this is to create a new MDB file and import ALL objects while you are connected to you unsecured MDW file

Cheers, Andrew
Assuming you secured the database correctly, you have to log in as an administrator and add the Admin user back into the Admins group.  Make sure that the Admins group has full permissions on all objects (it probably has).  You can then logout and (if necessary, join the system.mdw default workgroup and) then create a new blank database and import all objects.  The new database should allow the default user (Admin) full permissions.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts


Hi Sage

Can you give me directions more specific as to where i should click (which menu etc) to do this..
And what do u exactly mean by 2importing all objects"



Hi thanks Sage..

your solution worked...

Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.