Typo3 Developer: MS Access Tutorial - 2
How to install the MyOLEDB Provider
The data type of the usergroup field in the fe_users table is OLE Object. When viewed online this field displays the front end user usergroups as a list of usergroup unique ID numbers (i.e. 2,5,12). If you view the fe_users Link Table in MS Access you will see this in the usergroup field: "OLE Object." You will need to install the MyOLEDB Provider v3.0 to enable communication between the MS Access Link Table and the Typo3 fe_users table usergroup field.
Download MyOLEDB3.exe from dev.mysql.com. Run the program to install MyOLEDB Provider v3.0 on the computer with the MS Access database. Now you can use Visual Basic ADO to interact with the usergroup field of the fe_users Link Table. The following just gives you an overview of what your OLE DB / ADO connection parameters would be. (Do not do this at this time. We will go into this in more detail later.)
- Provider: MySQLProv
- Location: your Typo3 server's IP address
- Data Source: your Typo3 database name
- User: your Typo3 database user account's username
-
Password: the password of your Typo3 database user
A connection function would look like this (This is just an example. We will go into this more further along.):
'connect using ADO and MySqlPov which are both OLE-friendly
Dim con As ADODB.Connection
Set con = New ADODB.Connection
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
con.Open "Provider=MySqlProv;Data Source=typo3db_sitedb;
Password=xxxxxx;User ID=typo3db_access;Location=NN.NN.NN.NN"
rs.Open "SELECT usergroup FROM fe_users WHERE
(((fe_users.uid)=" & [uid] & "));", con
Reference the Microsoft Activex Data Objects 2.8 Library
View the code behind MS Access forms by opening the VB Editor.
|
 |
In Tools -> References check Microsoft ActiveX Data Objects 2.8 Library.
|
 |