Recent content by RyanJames

First of all, I would like to thank everyone for their help. I've been working with Access/SQL for a very long time, so it is unusual to run into something I haven't seen before. I was able to correct the issue and it was actually on the SQL Server side, or at least in how Access handles keys...

I ran all the compacting and reorder tools I know of with no luck. I even recreated the table that seems to be giving me issues completely including keys and indexes and ran an insert statement to repopulate it, but that resulted in the same problem. I might create a copy of the DB and see if I...

All, Just a follow up, I found a machine that was patched most recently back in mid April and encountered the same issue. I will continue to update this post. I am going to try refreshing tables one by one to see if I can narrow it down to a specific table.

Thanks for the welcome and the info. I am in fact on 365 at the moment and also have a 2016 machine displaying the same issue. I will track down the patch notes and see if I think I might need a roll-back.

Hi All, I've been lurking these forums for a very long time, but I finally have an issue that I cannot resolve with what is already available. I've been programming access VBA for about 14 years, but I simply have no clue with this one. As the title suggests, I have an Access frontend with a...