Click here to close this tab and return to the app.

How to use Microsoft Access as a front-end for a MySQL Database

To connect Microsoft Access (MS Acess) to the edit tables in a MySQL database, you will need to download and install the MySQL ODBC Connector. Look for the Connector/ODBC 5.1.11 MSI Download for your platform.

Then, use these instructions for the setup: 21.1.5.4.3. Using Microsoft Access as a Front-end to MySQL

Use the instructions here to set up the data source: 21.1.4.3. Configuring a Connector/ODBC DSN on Windows

Here is the information you need to set up the data source:

  • Data Source Name: Edit Tables on Aten
  • Description: (leave blank)
  • Server: mysql.atensoftware.com
  • User: (provided by email)
  • Password: (provided by email)
  • Database: (provided by email)

Microsoft Access crashes when linking tables if the name of the MySQL table is too long. We will set up your tables with short names (less than ~15 characters) to avoid this. Each table also needs to have a primary key defined.

Topic:

General Information for Online Merchants

Lasted Updated: September 20, 2012