Bug #94390 Linked table in MS Access shows as ***deleted***
Submitted: 18 Feb 2019 21:32 Modified: 18 Feb 2019 22:35
Reporter: Richard Schroth Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:8.0.13 OS:Windows (Office/Access 2015 )
Assigned to: CPU Architecture:x86
Tags: access, deleted, linked table

[18 Feb 2019 21:32] Richard Schroth 
Description:
Sometime when opening a table or query some or all of the records appear as deleted.  If you then select "Refresh All" on the menu bar the records will appear.  

How to repeat:
Not sure exactly.  It seems to usually occur after a record has been inserted or updated.  It also appears that it may depend on what data types are used in the record, or perhaps what some of the advanced settings are in the ODBC connection. 

Suggested fix:
Either document the proper settings to use when linking tables in Access, or come up with a new version of the ODBC driver that eliminates this issue.
[18 Feb 2019 22:35] MySQL Verification Team 
Thank you for the bug report. Duplicate/releated to https://bugs.mysql.com/bug.php?id=92947.