Unanswered: Link to remote mySQL table from MS Access
I am trying to use MS Access as a front-end to a large MySQL table on a remote host. I can link to the table, and look at its structure with the design view in Access. But if I try to look at the table in datasheet view, all cells are marked #Deleted. I can, however, import the table into Access, and all the information comes across properly.
I can't seem to find anything in the MySQL documentation to solve this problem. Also, I don't know if this thread should be on this forum or the one on Access. I would greatly appreciate any help anyone can give me on this!
PS I have enabled Return Matching Rows in the ODBC configuration, and I have the latest SP for Access 2003.