How to determine the .mdw that a db is set to

[vb6novice]

Is there a way in Access 97 to open a database and determine what .mdw file the database is using for security settings?

 

[jsteph]

use in the debug window
?dbengine.systemdb
--Jim

 

[JoeAtWork]

It would be using whichever MDW file is pointed to in the shortcut, e.g. if the target in the shortcut is....

"C:\Program Files\Office97\Office\MSACCESS.EXE" "C:\Projects\AppDev.mdb" /wrkgrp "C:\Projects\MySystem.mdw"

.... it is using MySystem.mdw in the "C:\Projects" directory.

If "/wrkgrp" isn't specified, it would use the default System.mdw file.

 

[jsteph]

...but remember, the 'default' .mdw file isn't necessarily 'system.mdw', it could be anything chosen in the last running of the wrkgadm program.
--Jim