Linking to Remote Mysql Tables - Microsoft Access Forum


	Back to Access Forum Comments List

Linking to Remote Mysql Tables

A Glenn Yesner

7 hours ago

I'm trying to link an MS Access front end to a remote MySQL backend. I've got the MySQL connector on my computer and it connects to the remote back end. The Access database "Tables" group in the Navigator window shows the tables are linked. When I open the table to review the data every field in every row displays #Deleted. All the field names show up at the top of the columns and there are the correct number of data rows for that table but no data just #Deleted.

However, I can import the desired tables and I get all the data and table field names, everything.

With a different MS Access database linking to a different MySQL database I didn't have this problem with linking tables.

Does anybody have any experience with linking MySQL tables to MS Access databases that can shed a little light on this issue?

Alkan Toykan @Reply

6 hours ago

Hi Glenn. One thing I'd check first is whether the MySQL tables have a proper Primary Key or at least a unique indexed field. I've seen Access display #Deleted for every record when it can't uniquely identify rows in a linked table, even though the correct number of records appears. A few questions that might help narrow it down.
- Do all of the MySQL tables have a Primary Key?
- Are the Primary Key values truly unique and have no Null values?
- If you relink the tables, does the behavior change?
- Are there any unusual field types that Access/ODBC might not handle well?
- Are you using the correct MySQL ODBC Connector for your version of Access?

Since you're able to import the tables successfully, the connection itself is probably OK. That makes me think the issue is more likely related to how Access is interpreting the linked table structure. When you linked the tables, did Access automatically recognize a unique identifier, or did it prompt you to select one? That might provide an important clue.

	Alex Hedley @Reply 6 hours ago
Have you got MySQL Workbench installed on your machine you can check with to?

Next Unseen