Re: MySQL/ Access newbie problem: Access DB not editable - please help

> [JS] Are you using ODBC so that Access can update a MySQL database?

Yes, exactly.

> 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'm not sure if I completely understand you but it was by opening one of the
linked tables that I discovered that I couldn't amend data in the table but I
could add new entries.

Thanks

Ian


-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]