The MySQL ODBC 5.1 driverĪppeared in the list of data sources, and to complete this connection, I had to re-enter my credentials, which makes me wonder if step 4. FINALLY, I was able to connect to the remote database in MS Access. I used my MySQL database credentials in the ODBC Data Sources (32-bit) app to successfully establish a connection to my remote database.ĥ. I downloaded the 32-bit driver msi file from Ĥ. I installed (reinstalled?) the MySQL ODBC 5.1 Driver (32-bit) on my computer. I am not convinced this was necessary, because of the next step.ģ.
MYSQL DRIVER WINDOWS 10 DRIVERS
I installed the MySQL Workbench, along with the 32-bit and 64-bit drivers (I thought), on my computer.
MYSQL DRIVER WINDOWS 10 HOW TO
I am about 80% confident this was a necessary step, and the referenced page was the only place I found that told me it was necessary and showed me how to do it.Ģ. To do this, I followed the instructions here: I set up a remote ODBC connection on my server, where I had already built the database and a table to go in it. The steps listed belowĪre in addition to the steps listed above.ġ. There have been a LOT of them, and a large percentage were non-productive, which you don't need to hear about. Here are the steps I took to solve the issue, as near as I can remember. Thanks in advance for any help you can offer. What else am I missing to get MS Access to connect to and link tables from this MySQL database (that is NOT on my computer)?.How can I get the MySQL ODBC driver(s) to appear in the MS Access "Create New Data Source" driver list box?.I have been able to successfully connect to the database using MySQL Workbench, and to see the ReadingLog table and all the fields (columns) in it.I have been able to successfully connect to my new MySQL database on my server using both the 32-bit and the 64-bit ODBC data sources.I have gone to and installed all their recommended tools.I created a database, table, and appropriate fields on one of my websites, using CPanel > PHPMyAdmin.This brings up the "Create New Data Source" dialog, with a "Select driver." list box.Įvery source and tutorial I've found so far shows the MySQL ODBC driver already appearing in this list box,īut that driver does not appear in my list box (although a lot of non-English Microsoft drivers do appear there).in the "Create New Data Source" dialog, click the "System Data Source" radio button and click NEXT.in the "Select Data Source" dialog, click the Machine Data Source tab, then click the NEW button.in the subsequent dialog, select "Link to the data source by creating a linked table" and click OK.
External Data > New Data Source > From Other Sources > ODBC Database.THE PROBLEM: I go through the entire process in Access as follows: I am currently using the latest available versions of Win10 and MS Access (Office 365) as of August 2019. THE GOAL: Connect a Microsoft Access front end via linked tables to a MySQL database created on one of my websites (using PHPMySQL). The Original post is at the top - the solution I found is below.
0 kommentar(er)
