ODBC Connector and MS ACCESS 2010 not communicating - Source

Revision: 88963
User: Roger Mare
Date: 2019-09-06 12:12

My experience is really with MS SQL server so it has been difficult to get my set up working.
I have a synology DS215J running MairiaDB 10. Because it runs on synology there is no real access to any of the cfg settings.
I am trying to use MS access (2010) on my Windows 8.1 machine as a front end for the database and I want to use ODBC to link the two.

The database is up and functioning on the synology and there is a simple first name last name table for proof on concept.
I am using the latest 32b Maria ODBC connector (the 64b does not connect to the database). and the test DSN function works and you can read the tables etc. All the options on the connector are at their default values

When I am in MS access and I try to link the database I choose external data/ODBC database
Select Link to the data-source by creating a linked table
I then choose the previously created  (& tested) ODBC source
I am shown the tables but when I click OK I get the error message " Reserved error (-7731); there is no message for this error"

I am at a loss how to progress how to debug what is going wrong or to fix it and I wondered if anyone has come across this problem before and can offer a direction to go in?

Answer

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

ODBC Connector and MS ACCESS 2010 not communicating - Source

Answer

Products

Services

Pricing

Resources

About Us

Download MariaDB