RE: MySQL/ Access newbie problem: Access DB not editable - please help
"Jerry Schwartz" <[email protected]> Thu, 6 Aug 2009 14:36:22 -0400
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Organization | The Infoshop by Global Information |
| Message-ID | <047201ca16c4$d0110d60$70332820$@com> |
> >> [JS] I am not sure if this is the exact problem you are having, but I >have >> had an issue with Access not allowing me to run update queries against >MySQL >> until I have opened at least one table. Try that. > >Do you mean I should create a table in Access and link that with MySQL? > [JS] Are you using ODBC so that Access can update a MySQL database? That is the situation I have. To do that, you have to import the MySQL tables into Access as linked tables. That's where I found that I had to open one of the linked tables before running an Access query to update anything in MySQL. I am using macros or VB code anyways, so I just open the smallest linked table in regular data view mode before running any queries that update MySQL tables. I found this solution by accident. I think it must be a bug in Access, although I have not had the time or inclination to pursue it. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]