I have a number of DBs with Access security working just fine... I want to create a new DB with no security that will load for all users without going through the .mdw login security. I created the mdb and it requires user login.
Any way to do this?
You might want to consider reinstalling MS Access on your computer it should set the default .MDW back to the default settings. If you just edited the default .mdw then you may have a few problems to over come. I hope you created a different .mdw so this wont hurt too bad.
There most certainly is. I have a post in another thread. Let me look it up and it will explain exactly how to do just what you are wanting... a different .mdw for each database or you can create one and use the same one you created for multiple databases it is totally up to you.
I can't seem to understand how this allows different mdw's for each mdb/e. I tried it and whenever I go into access using the command line on the last page of the document, it changes my mdw to a new one in the primary /Program Files/Microsoft/Office10 etc.
I rejoin the proper mdw and exit. When I go back into access I am still linked to the proper mdw. All I really want to do is assign a specific mdw to each mdb.
Perhaps I am a bit thick today.
Use the MSAccess help "Remove User-level security". It works just fine. But... I looked at your script. Don't understand how that creates a different mdw for each mdb. It just looks like the standard mdw (security assignment) routine. I guess my objective is to have Access automatically join a predefined workgroup upon start up. If they open a different mdb it joins a different predefind mdw.
I'm sorry if I am dense today. Finally finished getting access/vba to de/relink tables. Works like a charm, but it took a while to get there.
thanks for all your help.
but when I tried it, Access ignored SystemDBX.mdw and created a new system.mdw. It seemed to copy the characteristics of SystemDBX.mdw to the system.mdw, but I don't understand why. Perhaps what I should do is create another mdb with a different mdw and try each one separately one after the other and see if they recognize proper security.
Yea try several different ones. My main database is on security. All the rest of them arent, and it shows that difference... I will paste what is supposed to be in your short cut to access the database.
"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "C:\Documents and Settings\The Vortex\My Documents\CT Industries\ctrim.mdb" /WRKGRP "C:\Documents and Settings\The Vortex\My Documents\CT Industries\Secured.mdw"
The database file is supposed to come first. (I noticed you had the .mdw first)
"C:\Documents and Settings\The Vortex\My Documents\CT Industries"