above was necessary.Ī huge THANK YOU to Daniel Pineault for his patience and links, and even more for his suggestion to create a DSN-less connection, which I am beginning to understand is what I will need to do if I want to distribute my Access front end to other users so they 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.ĥ.
#Ms access odbc driver driver#
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.ģ.
#Ms access odbc driver drivers#
I installed the MySQL Workbench, along with the 32-bit and 64-bit drivers (I thought), on my computer.
#Ms access odbc driver 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.
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)
