Problem with MS Access 1

[siftach]

I am using MS Access as a front end for my application, and I have recently converted my application to work with MySQL through ODBC, using the same Access front end.

In continous forms I have a problem: Whenever I add a new record, it appears as a deleted one. If I close the form and reopen it, it appears the way it should. This happens in forms only, when I add data through the tables or through queries it does not happen.

I am using MS Access XP, MySQL 4.0 and MyODBC 3.51.

 

[sleipnir214]

Start with the advice on this page:

http://www.mysql.com/doc/en/MyODBC_clients.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[siftach]

Problem solved - Thanks!