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

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote