#Deleted message on input with linked tables

[mazz2000]

Hi
I'm just doing an access form to link to a mysql daabase to update a websites products, using a odbc connection.

When i input a new record and go back to it i see only #Deleted in all fields i have to close the database and open again to see the data correctly.
Is there a way to cure this problem?

Cheers

Neil

 

[boblarson]

Have you tried putting

Me.Requery

in the ONCURRENT event of the form?

 

[RuralGuy]

Bob,
I'm thinking that would give you a forever loop!

 

[Ascaphus]

Hi
I'm just doing an access form to link to a mysql daabase to update a websites products, using a odbc connection.

When i input a new record and go back to it i see only #Deleted in all fields i have to close the database and open again to see the data correctly.
Is there a way to cure this problem?

Cheers

Neil

I had a similar problem with MySQL linked via ODBC into an Access front end. When the primary key of the SQL table was of type BIGINT the #Deleted replaced all data in the table. No refresh or relink or reboot would affect the outcome. Redefining the column to 'Integer' took care of the problem. I reposted this in the interest of helping the next person with the problem.

Matt