Typo3 Developer: MS Access Tutorial
How to manage usergroups via MS Access
Connecting to the Typo3 database from a MS Access database is done through Link Tables and a special driver. The driver manages the connection between the MS Access database and the Typo3 database which uses MYSQL. If you already have the MySQL ODBC 3.51.11 driver installed, then click here to see how to create a Link Table in MS Access to display data in a table that exists in the Typo3 database. However, if you need help with installing the driver, then read on because we will be covering that first.
How to install the MySQL ODBC 3.51.11 driver
To communicate between MS Access and the MySQL database that Typo3 uses, you will need to install a MySQL Connector/ODBC (MyODBC) driver. Download and install this on the machine with the MS Access database. The driver is available from mysql.com or dev.mysql.com. You will also find comprehensive documentation on driver installation at dev.mysql.com.
Assuming you are on a Windows machine, download the Windows driver and install it at this point.
Once it is installed, you will find the driver under your Control Panel\ Administrative Tools\Data Sources (ODBC).
|
 |
Add the MySQL ODBC 3.51.11 driver as a User DSN.
|
 |
Configure the driver.
- Server: Your Typo3 website IP address
- User: Typo3 database user name
- Password: Database user password
- Database: Typo3 database name
|
 |
Under the Advanced tab, check the following checkboxes:
- Don't optimize column width
- Return matching rows
- Allow big results
Click Ok to exit the current screen. Then, click Ok again to exit the ODBC Data Source Administrator.
If you ever need to update these configurations, simply highlight the user DSN and click the configure button.
|
 |
Create Link Tables to fe_users and fe_groups
Keep Typo3 database records and MS Access database records in sync by creating Link Tables. In MS Access, open a database and create a New -> Link Table.
|
 |
When the Link dialog box appears, select ODBC Databases from the Files of Type selection menu under the File name field.
|
 |
In the next window, select the machine data source tab. Then select the machine data source which in this case is Typo3. Then click the Ok button.
When the Connector/ODBC 3.51 - Driver Connect window appears, review your settings and click the Ok button.
|
 |
If the connection is successful you should see tables from your Typo3 database listed in the next screen. Select the tables that you want to display in MS Access as Link Tables.
|
 |
You will see the new Link Tables next to the other tables in your MS Access database.
|
 |