Odd table issue.

[kevlray]

So we have a FE/BE database that has an MS-SQL BE. In the past few days we have had it were one table was showing all the rows as #Deleted (in Access). They use Windows Authentication for rights to the database. I downloaded SSMS to see if the user had rights to the database and table and they did.

I re-install of Office 365 fixed the issue. Any ideas on what is going on. FYI: It appears it only affected only a few users (+20 users).

 

[Gasman]

Search here. Ms bug, update your driver, that appears to fix it.

 

[sonic8]

Any ideas on what is going on. FYI: It appears it only affected only a few users (+20 users).

This is a new issue in the new version 2205 of Access 365. Probably only the affected user already were updated to the newest version.
I wrote a summary about the issue here: Bug in Microsoft Access 365 Version 2205 - SQL Server NVarchar Primary Keys cause #DELETED in ODBC tables

 

[kevlray]

Thanks for the info. Fortunately for us. The re-install of Office 365 has fix the issue for us.