Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

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

    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.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Star Lounger
    Join Date
    Dec 2001
    Location
    Fredensborg, Denmark
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

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

  4. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

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

Posting Permissions

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