MS Access ODBC connection to mySQL database - Deleted records - just show #Deleted

[peskywinnets]

So I've set up an MS Access ODBC connection a remote mySQL database (shopping cart database) - I've deleted some linked table records on the remote mySQL database using MS Access ...they have deleted, but now whenever I open the - just shows #Deleted ...I'd expected them to actually disappear.

Do I have to do something else to actually get the deleted fields to disappear from view (link to a screenshot of what I'm seeing in MS access ... https://ibb.co/0nH3fsf).

 

[Dreamweaver]

I tried years ago using access ODBC connection to mysql ended up giving up and doing what I needed with vb6 that was a good 15-20 years ago

Mick

 

[AccessBlaster]

Have you tried to requery the record source?

 

[peskywinnets]

Thanks for the input, it might be a bug with the mySQL ODBC connector...

https://bugs.mysql.com/bug.php?id=92947

 

[jdraw]

Did you try the requery suggested in post #4?
If you close that table and reopen it, does it still show "deleted"?
Do you have primary key on the table involved?

You might be able to use the RefreshDataBaseWindow.

Good luck.

 

[peskywinnets]

Have you tried to requery the record source?

could you be a bit more explicit (as I don't know what you mean) ...do you mean delete the current ODBC linked mySQL table & then create a new ODBC link to it again?

If you close that table and reopen it, does it still show "deleted"?

This is a remote mySQL database running on a webserver ....being candid - I wouldn't know how to!

Do you have primary key on the table involved?

It's not my table (it was designed/created by Prestashop - they make Shopping cart software)

Here's a screenshot of the Table (MS Access Design View)....

You might be able to use the RefreshDataBaseWindow.

Not sure how I'd press that into play here, but thanks anyway

 

[AccessBlaster]

could you be a bit more explicit (as I don't know what you mean) ...do you mean delete the current ODBC linked mySQL table & then create a new ODBC link to it again?

If this were happening to me, I would at least try me.refresh or me.requery in the forms after update. Just to rule it out.

 

[arnelgp]

just maybe compact and repair after deleting the linked table.