MySQL Forums
Forum List  »  Connector/ODBC

MS Access ODBC Connector #Deleted for all fields on some tables
Posted by: Gabriel Franco
Date: May 31, 2022 02:23PM

Hello,

This #Deleted glitch seems to rear its head on different tables in my database depending on the particular version of Office 365 Home Premium I have deployed and also the version of Connector/ODBC.

Older versions behave as desired for the most part.

Referencing the version combination of Microsoft Office 365 Version 2204 (Build 16.0.15128.20248 Click-to-Run) and MySQL ODBC Connector 8.0.23, this version works as desired.

When using "Linked Tables" functionality, all rows are returned with no #Deleted showing.

Upgrading O365 to 2205 introduces odd behavior;

#Deleted is returned for all fields in all rows when viewing the table directly in table view, query, or form.

If "Localize Tables" is used, Connector/ODBC will pull down the entire contents of the table, seemingly without issue.

The behavior is limited to the "Linked Tables" behavior of MS Access.

Attached is an ODBC trace containing the error.

Options: ReplyQuote


Subject
Written By
Posted
MS Access ODBC Connector #Deleted for all fields on some tables
May 31, 2022 02:23PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.