Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access can't open MariaDB connected tables

Status
Not open for further replies.

Makino

Technical User
Nov 26, 2004
6
IT
Good morning Forum.
I have a strange thing happening with my software project.
Scenario: MariaDB installed on a Windows2012 server using XAMPP.
With Microsoft Access 2010 I decided to connect these tables to make queries more quickly than using the SQL language, that I don't know very well.
First I've installed MySQL connector 32 bit and made the connection with the MariaDB database. All OK. Connection succesfull!!
Then I've tried to connect the tables in Access....but I received the "OBDC error, can't open table"!!!!
I did a long search on Google and I noticed that in some cases was better to install the MariaDB connector instead of MySQL connector.
I did it...Connection succesful, OK, finally i was able to connect MariaDB tables in Access but......when i want to open the table i receive the error "Impossible execute the query, table not found"!!!!!!!
I don't know, now, what to do!!!!
Can anybody help me?
Many thanks in advance!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top