Importing an Access Database to a New MySQL Database

In order to create MySQL Server databases, MySQL 5.0 or later must be installed on one of the network servers or workstations (see Installing MySQL).

If another database is already open then you will need to close that database first before creating a new database (see Closing a MySQL Database). To import an existing At Your Service Microsoft Access database to a new MySQL database, select File  New Database  Import AYS Database to New MySQL Database from the main menu.

Navigate to the folder where the database you want to import is located and either double-click on the file name, single-click on the file name and then click the Open button, or type the file name in the File name field and then click the Open button. Click the Cancel button or press the Esc key to cancel without select a database to import.

The only MySQL connection type presently supported is the MySQL ODBC connector. Enter the corresponding connection parameter, and click the Login button to connect to the MySQL server. Click the Cancel button or press the Esc key to cancel without connecting to the MySQL server. The following table summarizes the connection type and parameters.

MySQL Connection Types

Connection Type	Description
ODBC DSN data source	An ODBC DSN data source utilizes one of the above connection methods configured as a System DSN within the Data Sources (ODBC) component in the Windows Control panel. Enter the name of the DSN data source.

 

If the connection to the MySQL server was successful then you will be prompted to enter the name for the new database. The name will default to the same name as the Access database without the .ays file extension. Either modify the name or leave it unchanged and press the Create button to create the new database on the MySQL server and automatically import the data from the Access database. A progress bar will track the progress as the database is created and imported. Click the Cancel button or press the Esc key to cancel without creating a database.

The actual name of the physical database on the MySQL server will be prefixed with “AYS_” to distinguish it from other databases on the same MySQL server (e.g. if the name “sample” is entered then the actual name of the physical database on the MySQL server will be “AYS_sample”).

After creating a MySQL database the name of the database must be configured in the MySQL Connector/ODBC system DSN in order for printing to work correctly (see Installing MySQL).

(See also Saving a Backup Copy of a MySQL Database, Creating a New Empty MySQL Database, and Importing an Access Database to a New Microsoft SQL Server Database.)

More:

Opening an Existing MySQL Database