Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    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?

  2. #2
    Super Moderator jscher2000's Avatar
    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:

    HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice9.0Access Jet4.0EnginesSystemDB

    Maybe you can find something similar for Access 97 and, if applicable, Jet 3.5/3.6.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts