I have an 2003 access database and the security mdw file located on our network. If a user doesn't have a network connection, then access uses the system mdw on the c drive. I would like to set the database to always use the network mdw file.
I checked the microsoft access website and they had a one line suggestion to create an autoexec macro and add vb code to set the mdw file when the database opens. Then, set the the main menu form to lauch this macro when the form open.
The only problem is they didn't provide the vb code to set the mdw file. Can someone help provide the vb code to use the network mdw file on open? I appreciate your help.
Regards,
Jeff
I checked the microsoft access website and they had a one line suggestion to create an autoexec macro and add vb code to set the mdw file when the database opens. Then, set the the main menu form to lauch this macro when the form open.
The only problem is they didn't provide the vb code to set the mdw file. Can someone help provide the vb code to use the network mdw file on open? I appreciate your help.
Regards,
Jeff