MyODBC, ESRI GIS and erm blank records

Hi,
I've got a bit of a problem but I guess I wont have been the first to encounter something of this nature. I'm using ArcCatalog to successfully establish a database connection with a MySQL database on a webserver via MyODBC 3.51. Once inside
ArcMap 8.3 using "Add X/Y Data" I can access the tables within the database, my problem lies in the fact that some tables in the database show all their values fine but others show only the field names and all the records are missing (same symptoms previewing in ArcCatalog).
I've read of similar problems relating to non standard querying but this is before any specific SQL query has been performed within ArcMap. I'd appreciate it if those familiar with the quirks would enlighten me as to how to rectify the situation, it's my first attempt at such a connection and it's essential for my current project.

Thanks In Anticipation

Ed

I'm not familiar with ArcCatalog, but, off the top of my head...

1. Check to be sure you have the appropriate permissions on the tables that are giving you problems.
2. Verify that the problem tables are set up 100% by the book for ArcCatalog.
3. Verify the query, and run it in a non-scripted environment... e.g. the mysql command line interface, and look at the error and see if you can resolve it.
4. If the query seems valid but still isn't returning rows, try to rewrite conditionals and joins to broaden the criterion and make sure it's not an error in the query itself.

If none of that helps, let me know what happened.

Thanks for the reply, I'll give your suggestions a go when I next have the chance. As far as 1, 3 & 4 go I think that's all fine, I think it might be a case of needing to look at the datatypes and how ArcCatalog treats them as per 2. IIRC the tables that work fine I created from the command line and the troublesome ones were created with PHPMyAdmin so possibly some discrepancy there.