How to auto connect and auto disconnect from mdw file

[gazelle04]

I have an access database which I want to be secured by User Level security. But the problem is the moment you use the User Level security for a particular database, the next time you use Microsoft Access it will still default to the last connected MDW file you use. Using User level security affects the whole Access not just one database.

How can I auto connect or auto disconnect access to a particular MDW file.

[ADezii]

I have an access database which I want to be secured by User Level security. But the problem is the moment you use the User Level security for a particular database, the next time you use Microsoft Access it will still default to the last connected MDW file you use. Using User level security affects the whole Access not just one database.

How can I auto connect or auto disconnect access to a particular MDW file.

You can use a specific Workgroup Information File when Access starts via a Command Line Argument (/wrkgrp), as in:
[CODE=text]
"C:\Program Files\Microsoft Office\Office\M SACCESS.EXE" "C:\Test\Test.m db" /wrkgrp "C:\MDW Files\MyMDW.mdw "[/CODE]