Forum Discussion
walsh61850
Mar 21, 2024Copper Contributor
Primary Key dropped on my table.
Why does my table lose its primary key? I set a primary key to a number and date, so as to NOT allow duplicates for that day. Every now and then, I have duplicates. When I look at my table in desi...
walsh61850
Mar 21, 2024Copper Contributor
OK. I will do that. What could cause the corruption. Other tables do not seem to be affected.Tom_van_Stiphout
George_Hepworth
Mar 21, 2024Silver Contributor
walsh61850
Corruption is caused by different things, so we can only offer possibilities.
Someone shut down their computer while an Access write operation was in progress.
A network interruption occurred while an Access write operation was in progress.
Stuff happens.
Two users tried to update the same record at the same time, and the conflict wasn't resolved correctly.
Other stuff happens, too.
Corruption is caused by different things, so we can only offer possibilities.
Someone shut down their computer while an Access write operation was in progress.
A network interruption occurred while an Access write operation was in progress.
Stuff happens.
Two users tried to update the same record at the same time, and the conflict wasn't resolved correctly.
Other stuff happens, too.
- walsh61850Mar 21, 2024Copper ContributorThanks. I was afraid of that being so.