I have a question regarding to the MDW file. The default of system.mdw is store in "c:\windows\system" directory. And in the RegistryEditor "\HKEY_LOCAL_MACHINES\Software\Microsoft\Jet\3.5\Engines" I can found out where the MDW file located. My question is:
Is that a way by using VBA to change the location of the MDW file to the Network directory whenever users run the MDB file from Network ? So, that I don't have to go to each user's machine to Join the MDW file from Network. What I did is that I write the VBA code:
DBEngine.SystemDB = "\\Network\database\db.mdw"
and then put it in Autoexec macros, but it seems won't change the location of MDW whenever the MDB file opened. Is that a way to do it or any problem with the VBA code. Thank you very much.