Skip to main content
Skip table of contents

Access Microsoft Access Databases using 64-Bit applications

If you want to use the “Microsoft Access File DSN” in a 64-bit program like MTE 8 or DBM 6 you must provide a 64-bit compatible *.dsn file, as well as 64 bit compatible drivers”.

Enable saving to a local access database using 64-bit applications and drivers

Install the 64 bit drivers

  1. You should have Admin64 (latest is v3.6.4463.0) installed in the 64 bit DigaSystem folder (usually C:\Program Files\DigaSystem or C:\Program Files\DigaSystem64). If not, install it.

  2. Open Admin64 > Databases > Manage data sources > Drivers; you should see something like this:

image-20260204-101319.png

  1. Download and install Microsoft 365 Access Runtime https://support.microsoft.com/en-us/office/download-and-install-microsoft-365-access-runtime-185c5a32-8ba9-491e-ac76-91cbe3ea09c9

  2. Reopen Admin64: you should see the new drivers installed:

image-20260204-101510.png

Add a 64 bit compatible .dsn file

  1. Prerequisite: you should have DigaSQL64.dll version 3.20.3496.0 or newer installed in you 64 bit DigaSystem folder.

  2. Locate the original *.dsn file path in the local parameter “Digas\Database\\FileDSN” parameter.

parameter.png

  1. Make a copy of the .dsn file, usually digasloc.dsn and rename the copy e.g: digasloc64.dsn

  2. Modifiy the new file with any text editor and change the line “DRIVER=Microsoft Access Driver (*.mdb)” to “DRIVER=Microsoft Access Driver (*.mdb, *.accdb)”.

32-Bit.png

32-Bit dsn

64-Bit.png

64-Bit dsn

  1. Provide the path to the new file with the additional parameter “Digas\Database\\FileDSN64” (supported in DigaSQL64.dll from version 3.20.3496.0 onwards)

parameter2.png

Enable saving to a Global table using 64-bit applications and drivers

Prerequisites

Everything above in this page

Add 64-bit DSN for ODBC data sources

  1. Open Admin64 as an Administrator

  2. Database > Manage data sources > SystemDNS > Add…

    image-20260210-145939.png

  3. Select SQLServer then Finish - a new dialog will open:

    image-20260210-155212.png

    1. Name: should be exactly the same as the 32 bit data source

    2. Server: your SQL server eg MACHINENAME\MSSQL

    3. click Next and continue the configuration, matching your settings for the 32 bit source

  4. You should see the new 64 bit datasource under SystemDSN

    image-20260210-155459.png

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close