Require .mdw without shortcut.

[ponderdj]

Hello,

I know that opening a database without specifying a different workgroup to use (in the properties of a shortcut) will automatically cause the db to use the system.mdw file. I want to leave my system.mdw intact, but force the database to use a different .mdw as soon as you open the database, without clicking on a shortcut.

How can I make two seperate databases refer to a single .mdw without using a shortcut.

Thanks

 

[jsteph]

How then are you opening the database? If you dbl-click on the .mdb file in, say, windows explorer, it does a registry lookup and uses ShellExecute to open msaccess.exe, which will use the default .mdw (not necessarily system.mdw).

The .mdw is related more to msaccess.exe than to any .mdb, so what you want will require some sort of shortcut or proxy exe.
-Jim