#Deleted - Access DB / Linked Tables
Posted on 2005-05-04
I had an issue today which is making me question the reliability of an Access database (using SQL Server linked tables) that we currently employ.
One of my users reported that while viewing data through a query, the values in a single field all changed to "#Deleted"
When she closed the query and re-opened, all the records had been deleted. She was the only person accessing the data at that time.
I am able to recover from a backup, but this was rather disturbing. Any ideas what could cause such a thing?
Has a "fishy" feeling to it, but now I'm second guessing everything.