Recently, users of O365 Microsoft Access have been getting #Deleted on all records when using various backends (SQL Server, mySQL, etc) using certain data types as a primary key.  This is a bug that was introduced in build 2205 a little over a week ago.

The Microsoft Access team has done some lightening fast work on this and is rolling out a fix now.   If you are on the current channel, make sure you run your Office Update if you are experiencing this problem.   If you are on the semi-annual channel, the fix is still in the process of being rolled out.  

A work around is to revert back to an earlier version, or use ODBC v 17 drivers.
1
LVL 1

Comment

by:Mik Mak
V13 drivers also work ;)
0
LVL 69

Author Comment

by:Jim Dettman (EE MVE)
Note that Microsoft has now rolled out a fix in all channels for this.   Make sure to do your updates.
0

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month