#AMPPS MY SQL DATABASE WIZARD DRIVERS#

To check if you have the ODBC driver installed, click “Open ODBC Administrator” to open the system ODBC tool and look at the Drivers tab. Open MySQL Workbench and start the Migration Wizardįrom the main MySQL Workbench screen you can start the Migration Wizard by clicking on the Database Migration launcher in the Workbench Central panel or through Database –> Migrate in the main menu.Ī new tab showing the Overview page of the Migration Wizard should appear. Type the following command to grant access:Ĭ “GRANT SELECT ON MSysRelationships TO Admin”.To confirm that you’re logged in as “Admin”, type the “? CurrentUser” and press Enter, in the “Immediate” panel:.Under the “Database Tools”, click the “Macro -> Visual Basic” button to open the VB console.Preparing a Database Under MS Access 2007 Unfortunately, the Access UI for that seems to change every version, but we’ll cover at least version 2007. The steps to grant read access to Admin are explained below. That table is protected against read access even to the Admin user, so if you try to migrate without opening up access to it, you will get an error like this: Record(s) cannot be read no read permission on 'msysobjects'. MS Access stores relationship/foreign key information in an internal table called MSysRelationships. As for the destination MySQL server, you can have it in the same local machine or elsewhere in your network. Preparationīecause MS Access ODBC drivers are only available for Windows, migrating from it is also only possible from Windows. This tutorial should help you get your Access tables, indexes, relationships and data in MySQL.

MySQL Workbench 6.2 introduces support for MS Access migration.

Ampps my sql database wizard