NOT DUPLICATE: 'Cannot open a database created with a previous version of your application.

Hello,

I am working on a Python script to interact with gINT data.

I am using the pyodbc module. I can access some gINT files where others throw the following error in Python:

(0, 'DAO.Workspace', 'Cannot open a database created with a previous version of your application.', 'jeterr40.chm', 5003041, -2146825247)

However, if I go to the file location and double-click, it launches correctly in gINT. If I change the extension to .mdb or .accdb and try using Access I get an error message with the same error "Cannot open a database created ...."

I am specifying the connection string as

conn_str = (

r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=' +

filepath +';')

Any directions/help here would be much appreciated!

Thanks

Parents

0 Online Jesse Greenwald Wed, Jun 29 2022 1:36 PM
This is a bit of a guess, but check out this article, particularly the section on Older Projects and the linked article with a resolution.

If you convert the gINT project to the newer Access version, does the error go away? There are probably some ways to do that programmatically with your Python script if you encounter one of these older files. I'm not sure of ways to do with the Access DB Engine directly, but you could probably do it with gINT Scripts.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Online Jesse Greenwald Wed, Jun 29 2022 1:36 PM
This is a bit of a guess, but check out this article, particularly the section on Older Projects and the linked article with a resolution.

If you convert the gINT project to the newer Access version, does the error go away? There are probably some ways to do that programmatically with your Python script if you encounter one of these older files. I'm not sure of ways to do with the Access DB Engine directly, but you could probably do it with gINT Scripts.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data