Results 1 to 1 of 1
  1. #1
    Join Date
    Apr 2009

    Red face 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.
    Last edited by DwayneC; 04-28-09 at 21:43.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts