MySQL Forums
Forum List  »  Microsoft Access

My querys is read-only (linked to MySQL)
Posted by: Liviu Stoica
Date: October 15, 2004 09:50AM

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!

Options: ReplyQuote

Written By
My querys is read-only (linked to MySQL)
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.