Connecting Access and MySQL
This is a discussion on Connecting Access and MySQL within the MySQL forums, part of the Database Server Software category; --> Hi, I try to connect MySQL and Microsoft Access. I loaded mysql-connector-odbc-3.51.12. It is installed and configured. When testing ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 08:30 AM
| ||||
| ||||
 Connecting Access and MySQL Hi, I try to connect MySQL and Microsoft Access. I loaded mysql-connector-odbc-3.51.12. It is installed and configured. When testing I get a confitmation: Succes, connection was made. Trying tot make connection form Access 2003 I get the message [MySQL][ODBC][User cancelled]. I use the same username as calling MySQL form PHP (with succes): 'User'. What's going wrong? I use MySQL 4.0.20 Piet      |
|
02-28-2008, 08:30 AM
| |||
| |||
| Re: Connecting Access and MySQL On Mon, 2006-03-20 at 12:29 +0100, Piet wrote: > Hi, > > I try to connect MySQL and Microsoft Access. > I loaded mysql-connector-odbc-3.51.12. It is installed and configured. When > testing I get a confitmation: Succes, connection was made. > Trying tot make connection form Access 2003 I get the message > [MySQL][ODBC][User cancelled]. > I use the same username as calling MySQL form PHP (with succes): 'User'. > What's going wrong? > I use MySQL 4.0.20 > > > > Piet > > I'm not sure how you're trying to connect, but I've always had success by linking the tables. Here's a quick tutorial that explains the process: http://www.itc.virginia.edu/desktop/.../msaccess.html Hope this helps! Scott |
|
02-28-2008, 08:30 AM
| ||||
| ||||
| Re: Connecting Access and MySQL I did read your help and tried this: Do not connect from the controlpanel, but direct from access. It worked! Thanks. "Scott" <nospam@nospam> schreef in bericht news:1142963125.8266.12.camel@localhost.localdomai n... > On Mon, 2006-03-20 at 12:29 +0100, Piet wrote: >> Hi, >> >> I try to connect MySQL and Microsoft Access. >> I loaded mysql-connector-odbc-3.51.12. It is installed and configured. >> When >> testing I get a confitmation: Succes, connection was made. >> Trying tot make connection form Access 2003 I get the message >> [MySQL][ODBC][User cancelled]. >> I use the same username as calling MySQL form PHP (with succes): 'User'. >> What's going wrong? >> I use MySQL 4.0.20 >> >> >> >> Piet >> >> > I'm not sure how you're trying to connect, but I've always had success > by linking the tables. Here's a quick tutorial that explains the > process: > http://www.itc.virginia.edu/desktop/.../msaccess.html > > Hope this helps! > > Scott > |
Linear Mode
