Connecting MS Access Report with MySQL Database (1 Viewer)

rpk2006

Passionate Programmer
Local time
Tomorrow, 00:55
Joined
Jul 9, 2006
Messages
4
I have an Access Report and I want to connect it with MySQL Database. How can I do that?
 

peej228

New member
Local time
Today, 12:25
Joined
Oct 21, 2006
Messages
5
Linked Tables

First intall mysql odbc driver 3.51 then setup odbc connection to mysql database (control panel, administrative tools, odbc, system dsn tab).

open access then in the tables section of access right click and select link tables in Files of type select odbc the select the odbc connection you setup earlier click on the tables you want and click ok.
 

Users who are viewing this thread

Top Bottom