UNDO an MDW file?

Howdy,
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?

Thanks,
Bob
BobMinerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
JimMorganConnect With a Mentor Commented:
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.

Jim
0
 
WonHopCommented:
I don't think you can undo an mdw file.  You might have to Import everything into a Blank database.  
0
 
jschrismanCommented:
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.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
BobMinerAuthor Commented:
jsChrisman,
>>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.
Bob

WonHop,
jschrisman answered my question, but thanks anyway for your response.
0
 
WonHopCommented:
Your are welcome
0
 
BobMinerAuthor Commented:
Funny you should mention the 2000/'97 incompatibility...it happend tonight at work.
Thanks,
Bob

0
All Courses

From novice to tech pro — start learning today.