MySQL Forums
Forum List  »  Microsoft Access

Advanced Search
New Topic

Re: #Deleted rows: discovered the cause; but no solution yet
Posted by: Grace Coronado
Date: March 10, 2006 12:36AM

We now discovered what causing the #DELETED rows when viewing linked MySQL tables in MS Access. It seems that MyODBC can't properly handle records with FLOAT or DOUBLE fields which are part or defined AS PRIMARY KEY.

That's the reason why, when we remove the key definitions of the 'problematic' tables the #DELETED rows disappeared.

Hope we can find the solution from here.

- Grace

Navigate: Previous Message• Next Message
Options: Reply• Quote




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.