system.mdw

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with it's very own "system.mdw" file.
All security has been set, and without this file you can not open the
database.

This database has a front end that users install on their workstation, and a
backend which resides on a server. These databases point to the custom mdw
file which is also on the server so everyone should be able to access it.

However, upon installing the front end on a user workstation, by default
their Access points to the user's default system.mdw file on their
workstation - not the one on the server associated with this database. I
don't want the install process to have this manual element of having to
redirect everyone's workgroup admin file to the server one, it should do it
automatically when opening this database. How can I ensure this?

Also, this redirection leads to a second problem. If the user, with the
redirection of the workgroup admin file to the one on the server for the
stated database, attempts to open some other Access database, they are asked
for the user login information associated with the original database stated
above. It seems, this redirection, becomes the new default .mdw file for all
Access databases, and has to be manually changed each time a user wants to
open a different database?

Thanks in advance for your help.
 
You can use a shortcut to open the database, supplying the needed
information in the shortcut's command line.

Example:
"<path>\msaccess.exe" "<path>\MyDatabase.mdb" /wrkgrp
"<path>\MyWorkgroup.mdw" /user UserName /pwd Password

The <path> can be a drive letter directory, such as "C:\Program
Files\Microsoft Office\OFFICE11\MSACCESS.EXE", or a UNC path, such as
"\\ServerName\ShareName\SubfolderName\MyDatabase.mdb". You have to include
Msaccess.exe on the command line or the switches will be ignored unless you
modify the registry setting for opening Access by double clicking on a
database file.
 
Thanks for your help. I think I understand what you are saying.
When you say command line however, do you mean the "Start in" field which is
on the 'Shortcut tab' in the 'Properties' of the database desktop shortcut?

Thanks
 
Back
Top