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!!!
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!!!