Table Does Not Exist

[Herman Geldenhuys]

Hi there.

We moved an Access Database over to MySQL and it works almost great. The error that I get is generic not related to the Access Migration forum.

I've set the tables in MySQL to be read as case insensitive, but whenever I read data from MySQL(saldb.Budget), using the incorrect case name of a table(saldb.BUDGET), the server tells me that the particular table does not exist.

Then without changing anything, once I open the database with Access--frontend--, or MySQL Command Centre the previous query works fine.

My problem is, everytime we restart the server, one needs to go and open up the database with MySQLCC or Access before everything works OK.

Is there a proper solution to my problem?

Thanks


Herman