UNDO an MDW file?

While fiddling around with the security of my access database project I set up this MDW file.  I have a shortcut on the desktop that runs access with the /WRKGRP suffix, prompts me for my password, and lets me in.  If I run the access.exe file directly from my office folder the login script comes up, but no password or user name will let me in; even to a bland database.  I realize its because the MDW file is now filtering all runs, but I'd like to undo the whole mess & return to a nice unsecure database where access starts up (without the password request) from the office folder or any .MDB file.  I don't want to adjust every occurence of the run command to go thru this mdw..I just want it gone.  Any suggestions?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I don't think you can undo an mdw file.  You might have to Import everything into a Blank database.  
You create/join a workgroup by running "wrkgadm.exe". The first time you run Access it creates a default system.mdw file in the "Windows/System" directory in Win98 or "WinNT\System32" in NT.

You can-

1) Run wrkgadm.exe and rejoin the system.mdw workgroup in the system directory.

2) Move the mdw file you think it's using to a different dorectory. If Access can't find the MDW file it needs it will start up with no security. The reason I say to move the file and not delete it is because you may need it to strip security off of any databases you have created using the MDW file.

What you have explained doesn't make any sense to me. I too have a shortcut on my desktop which gets into a particular database using a specific MDW file. However, unless I click on the actual shortcut Access will not use the MDW file because I have never joined a workgroup. The only way I know Access will always use a workgroup is if someone specifically runs wrkgadm.exe and joins the workgroup.

Hope this helps.
BobMinerAuthor Commented:
>>What you have explained doesn't make any sense to me. I too have a shortcut on my desktop which gets into a particular database using a specific MDW file. <<

This prompted me to do a search for MDW's...guess what? 2 system.mdw's.  I moved the one *not* in the win/sys & voila, good ol' unsecured access.  I then deleted the unwanted MDW. The "3rd" mdw that I made & new about, in fact, only effects the one MDB file as I intended....so YAY!

Thank you for answering the question.

jschrisman answered my question, but thanks anyway for your response.
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Your are welcome
Got to watch out for multiple MDW's with the same name.  Also if you are running two versions of Access, ie 97 and 2000, when you open 2000, it will dump you from the 97 workgroup that you are joined and put you in the default System.MDW.  They are supposed to be capatible but apparently not.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BobMinerAuthor Commented:
Funny you should mention the 2000/'97 incompatibility...it happend tonight at work.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.