Connecting to Access 97 Database

Talk about working with different database types

Moderators: ne_moj, zewa, vadimako, ne_moj, zewa, vadimako

AndyL
Junior
Junior
Posts: 22
Joined: May 18th, '10, 12:41

Re: Connecting to Access 97 Database

Postby AndyL » Feb 11th, '18, 18:57

Here's a workaround: use the MariaDB Connect engine.
https://mariadb.com/kb/en/library/connect-odbc-table-type-accessing-tables-from-another-dbms/

It's not particularly fast, but it works and somehow translates the MariaDB dialect of SQL to the Access dialect.

You can call stored queries in the Access database too.

AndyL
Junior
Junior
Posts: 22
Joined: May 18th, '10, 12:41

Re: Connecting to Access 97 Database

Postby AndyL » Apr 11th, '18, 14:54

Nope. I have given up for the moment. The MariaDB trick does work fine though.


Return to “Databases: different types implementation”