Access MDW File problem

Posted on 2009-02-17
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.
Question by:siva_iaf
  • 2
LVL 28

Expert Comment

ID: 23658265
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
LVL 77

Accepted Solution

peter57r earned 1500 total points
ID: 23658322
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.

Author Comment

ID: 23658422
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"


Author Comment

ID: 23658547
Hi thanks Sage..

your solution worked...


Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

839 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