How do you stop a Microsoft Access Database from requiring the use of the MDW file

I have a database that uses the MDW file for security to open.  Is there a way to stop it from requiring the MDW file and just open?
J.R. SitmanIT DirectorAsked:
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
+1 on Peter's comment as well, and here's a link to an MSDN article about de-securing a database:

Just be SURE that you restart Access, as stated in Step 7 above. Many people overlook this, and if you do you'll be using the same .mdw file that was used originally, and you'll be back at square 1.

Also note that quite often ULS was used for "user navigation" as much as it was for security reasons, so be SURE that you want to remove this before doing so. If you have a situation where UserA sees different forms than UserB, then you're using some form of "user navigation", and that could be based on ULS.
pdebaetsConnect With a Mentor Commented:
I believe that all Access .mdb database files require a workgroup file to open, the question is: Is User Security enabled? To enable User Security create a password for the Admin user. To disable User Security, remove the password for the Admin user.
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:
+1 on Peter's comment.  Access (JET) security is always "on" and a MDW is always required, even with A2010, which was supposed to have removed it.

 One thing though; Desecruing a DB if it has been secured involves a little more then changing the admin password back to a blank. The password only controls getting the login dialog or not.

 Full rights need to be assigned back to the user group and if your going to continue to use the same MDW file, the admin user will need to be added back to the admin group.

Easily manage email signatures in Office 365

Managing email signatures in Office 365 can be a challenging task if you don't have the right tool. CodeTwo Email Signatures for Office 365 will help you implement a unified email signature look, no matter what email client is used by users. Test it for free!

J.R. SitmanIT DirectorAuthor Commented:
Thanks, I'll test and post later
Jeffrey CoachmanMIS LiasonCommented:
..But remember that this is all predicated on the fact that you have authority and permission to do make these changes...

My guess is that this security was established for a reason, ...

J.R. SitmanIT DirectorAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.