MS Access ODBC connection to mySQL database - Deleted records - just show #Deleted (1 Viewer)

P

peskywinnets

Registered User.

Local time

Today, 09:18

Joined

Feb 4, 2014

Messages

576

• Sep 26, 2019

• #1

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).

 

D

Dreamweaver

Well-known member

Local time

Today, 09:18

Joined

Nov 28, 2005

Messages

2,466

• Sep 26, 2019

• #2

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

 

A

AccessBlaster

Registered User.

Local time

Today, 01:18

Joined

May 22, 2010

Messages

5,933

• Sep 26, 2019

• #3

Have you tried to requery the record source?

 

P

peskywinnets

Registered User.

Local time

Today, 09:18

Joined

Feb 4, 2014

Messages

576

• Sep 27, 2019

• #4

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

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

 

jdraw

Super Moderator

Staff member

Local time

Today, 04:18

Joined

Jan 23, 2006

Messages

15,377

• Sep 27, 2019

• #5

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.

 

P

peskywinnets

Registered User.

Local time

Today, 09:18

Joined

Feb 4, 2014

Messages

576

• Sep 27, 2019

• #6

AccessBlaster said:

Have you tried to requery the record source?

Click to expand...

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?

jdraw said:

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

Click to expand...

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

jdraw said:

Do you have primary key on the table involved?

Click to expand...

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)....

jdraw said:

You might be able to use the RefreshDataBaseWindow.

Click to expand...

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

 

Last edited: Sep 28, 2019

A

AccessBlaster

Registered User.

Local time

Today, 01:18

Joined

May 22, 2010

Messages

5,933

• Sep 28, 2019

• #7

peskywinnets said:

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?

Click to expand...

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

..forever waiting... waiting for jellybean!

Local time

Today, 16:18

Joined

May 7, 2009

Messages

19,230

• Sep 28, 2019

• #8

just maybe compact and repair after deleting the linked table.