By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,410 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

How to auto connect and auto disconnect from mdw file

P: 52
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.
Apr 22 '08 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,599
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:
Expand|Select|Wrap|Line Numbers
  1. "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Test\Test.mdb" /wrkgrp "C:\MDW Files\MyMDW.mdw"
Apr 26 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.