• detect the Access version of a database programati (Access 97/2000)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » detect the Access version of a database programati (Access 97/2000)

    Author
    Topic
    #365351

    Is there a method to detect the Access version of a database? If so, how.

    I want to be able to determine the version of a database (typically 97 or 2000) so that I can run JetComp automatically without having the user enter if it is Access 97 or Access 2000 version.

    Viewing 1 reply thread
    Author
    Replies
    • #563666

      Hi Andy,
      Using DAO, you can access the Database.Version property, which will give you the version of Jet that created the database, though if you’re using ODBC I think it returns the version of the ODBC driver.
      Hope that helps.

      • #563958

        Thanks Rory, that works fine and I have now found it in the help files after all.

    • #563667

      CurrentDb.Properties(“AccessVersion”) will return the Acces version (not the Office version).

    Viewing 1 reply thread
    Reply To: detect the Access version of a database programati (Access 97/2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: