This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have just signed up for Office 365 Family from Office 2021. I use Access for a club database which was created in 32bit and using ODBC for the connection to a remote server. My problem is that although I can create a working ODBC connection and see the database, I cannot open it from the latest Access program. I have tried all drivers but am unable to open the database, i would be eternally grateful for any ideas please.
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
If Access is 64-bit, then you have to match the ODBC to match, so you need to use the 64-bit MySQL ODBC drivers and use the 64-bit ODBC Admin app.
So you'll most probably first need to download and install the 64-bit MySQL ODBC drivers on your PC (have you done this yet?) and then create the DSN using the 64-bit ODBC Admin app.
Great news! Continued success with your project.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
What is Sapar_5? Is it a private data repository? Is it a MySQL based server? Is the database on the WEB or a WAN?
My suspicion is you are going to need to contact their tech support.
Thanks for the speedy reply
I use the Data Source Administrator (32-bit) and create a data source, ignore the top 3 (mdb,accdb) they were non working tests.
I then configure the Sapar_5 data and the connection test to the database on the server is successful.
I then open Access on the home form I immediately get the error message as the tables are linked to Sapar_Online. I go through the process of clicking External Data and navigating to the correct DSN and receive the following error.
If I attempt to use the 64bit DSA I get this but have no idea how to link to a database from here.
I have deleted all tables in case that would help but sadly not.
The tables are stored in accdb format.
I have toyed with the idea of trying to reload Office 365 in 32bit but am seeing this as a challenge now.
What data format is the data on this remote server? When you say you can see the database is that from Access? Can you see the tables?