Knowledge Base

KB10675 - SQL layers use Access 97 database instead of newer Access versions.

When Microsoft Access is selected as the SQL layer storage database, TatukGIS products generate new files by default to the Access 97 (MSJET) database format due to compatibility reasons. This is because Access 97 was the last version of Access packaged by default with the Windows operating system. Later versions of Access were distributed only with MS Office. If TatukGIS generated files to a later version of Access, the procedure would not work on any Windows computer without MS Office installed. (Still another issue is Microsoft later did not upgrade MSJET to support 64-bits.)

Although TatukGIS saves by default to Access 97, the software can read (open) SQL layer files stored in later versions of Access.

There are two options for converting Access 97 SQL layer files to newer a newer version of Access:

  1. ​Do this within Access, or
  2. Configure the database connector to generate files directly to any TatukGIS supported database and database layer format. Refer to KB10765 for guidance on connecting to various supported databases and database layer formats.

For local SQL database storage, TatukGIS recommends the free SQLite database engine. SQLite is faster than Access/MSJET, without the MSJET 2 GB maximum size limitation, and supports the 64-bit platform.

Created: January 20, 2006, Modified: January 04, 2016