Forum Discussion
Access 2019 #Deleted Table status (Field NVARCHAR)
Hi, There has been an issue regarding Access 2019 displaying #Deleted status on certain table, for only certain windows user profile. Based on my analysis: 1. This happen to only certa...
I'm having a similar issues I found this... I can't use the work arrounds he proposed but maybe your can
https://codekabinett.com/rdumps.php?Lang=2&targetDoc=msaccess-bug-v2205-odbc-deleted-nvarchar-primary-key
I should have noted the work around I am using is replacing the nvarchar PK with identity PK and re-adding the old nvarchar PK as a constraint. I have not tried but using a nchar as I read they are similarly effected and would cause more re-coding issues in my environment the the PK replacement. I'm also hoping Microsoft will bet even if the they do it might not be fast enough for my team.