This action could not be performed because the required table is missing

[bdam]

My first try at working with external ODBC data sources. MySQL is up and running, the DNS is setup, FileMaker sees the DNS, it's showing me the table I want to add, but when I do so I get the following error: "This action could not be performed because the required table is missing"

I gave the mySQL user full global access to everything. There are no scripts in this database. I just created this database, it's completely empty.

Any ideas as to what's going wrong?

[bdam]

I figured it out. MySQL will allow you to have spaces in the Database name but FM can't handle it. I renamed the database using underscores instead of spaces and it worked fine. I did a lot of reading and I didn't that mentioned.