Re: tables not seen when using odbc to connect access as front end to mysql backend

[Stephen Rynas]

Since others have not taken a stab at this, I will offer my thoughts. I am NOT and expert. Furthermre, I have not experienced this issue.

Since your database does not display itself as one of the options in the ODBC screen, your MYSQL permissions may be inccorrect; as in being too restrictive.

As an experiment grant all permsssions in for the database itself and all tables to your login ID and see what happens. Once you can "see" your database, you can revise the permissions to whatever would be appropriate.

PS: Just as an outside thought, enter MYSQL and to see if you see both your database and the the "test" database. If both databases are visible, make changes using MYSQL to the "test" database and see if you can see those changes on your local computer in Access. If that works, look a the permissions of the "test" database and compare those to your database.