vb to use mysql

[Hernan Gonzalez]

Hi, I'm a newbie in this matter but hopefully someone can help me. Here's the problem:

I have this visual basic application that connects to a ms access database via an ODBC connection, I have already exported the tables an data in such access file to a mysql database using "MyAccess" and configured the odbc connection to use myodbc with the server/user settings. When I start the vb application the following error appears: "[mysql][odbc 3.51 driver][mysqld 3.23.58]Table 'database.table' doesn't exist "

two things:
---- in the original and the exported database, the table names are uppercase letters.
---- changing all the table names to lowercase doesn't work either, a different error message appears.


what' going on here? what extra steps should have been taken?

I really appreciate any help