I have an Access 2007 database front end and a SQLServer 2012 back end, roughly 20 users. I've been having a problem of late with new records suddenly filling all fields with #Deleted#. It seems to be only on those that are in the process of being written.



I did a lot of searching and found MS suggesting that I use a pass-through query. I've read up on them and they're not difficult to create, but my efforts have not allowed me to actually write to the tables. Obviously I need to write/edit information.

I have two main linked tables involved in the form where the issue is occurring, CustomerInfo and AllVehicles, linked on an ID table. There are 250k records in the system as of now, and I need to be able to access, write, and delete records as necessary.

If anyone has any suggestions I'd greatly appreciate it.

Also, if anyone has any suggestions as to another way to deal with the #Deleted# problem I could use the help!