My querys is read-only (linked to MySQL)
I work with Win XP, Access 97 or Access 2003, MyOdbc 3.51.9, MySQL (from Win or Linux).
The table "Test" is linked to MySQL, and query "myQuery" is a query pass through.
The next query (myQuery: "SELECT Test.* FROM Test") is not updatable (and I defined primary key on the table Test).
My wish is to edit records from query MyQuery like in Access.
I try to open the query from code (DoCmd.OpenQuery "myQuery", acNormal,
acEdit), but the query is also real-only.
I observ one special case when myQuery become updatabe when I "Remove
Filter/Sort" form menu (but this case is aleatory and not work anytime)
Help me please and apologise for my english!
My regards!
Liviu
Subject
Views
Written By
Posted
My querys is read-only (linked to MySQL)
3325
October 15, 2004 09:50AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.