Skip to content

[faq] support for Access_97 and earlier

Jump to bottom
Gord Thompson edited this page Oct 4, 2020 · 1 revision

The ancient 32-bit Microsoft Access Driver (*.mdb) (a.k.a. "Jet") that ships with Windows has limited support for Access_97 database files. In Python_3 all strings are Unicode, but Access did not support Unicode until Access_2000.

Jet ODBC can work with Access_97 .mdb files with some limitations, e.g., as described in the Stack Overflow question here. However, the Access_97 format has been deprecated for many years and is now completely unsupported by modern versions of Microsoft Access.

Therefore this dialect does not support Access_97 files. Earlier file versions (such as Access_2.0) are also not supported.

Clone this wiki locally