Results 1 to 2 of 2
2001-12-12, 00:34 #1
- Join Date
- Jan 2001
- Serbia and Montenegro (Yugoslavia)
- Thanked 0 Times in 0 Posts
Using default System.MDW in connection string (VB6)
I have a connection string that I am using to access data in an Access 97 database. It is going to be loaded on various machines and I want to point it to the default system.mdw file specific to the machine it is running on. It seems to require a reference to the WIF or it errors saying that it is missing or opened exclusively by another user (where with some other parameters it is okay to just leave blank with a trailing semicolon.
Is there a way to reference the default system.mdw without telling it the full path?
2001-12-13, 04:57 #2
- Join Date
- Feb 2001
- Silicon Valley, USA
- Thanked 93 Times in 89 Posts
Re: Using default System.MDW in connection string (VB6)
I have two! c:Program FilesMicrosoft OfficeOffice and c:Program FilesCommon FilesSYSTEM (the latter of which has been updated more recently).
It appears for Access 2000 that you can retrieve this value from the registry:
Maybe you can find something similar for Access 97 and, if applicable, Jet 3.5/3.6.