Hi all,
I have a database with linked tables but shows some records as deleted. These records reappear if I press F5
I have tried to repair the database, update the ODBC driver and does not work
Someone could help me, thank you !!
Hi all,
I have a database with linked tables but shows some records as deleted. These records reappear if I press F5
I have tried to repair the database, update the ODBC driver and does not work
Someone could help me, thank you !!
Do you have the table open while you or someone "UPDATE/DELETE (not sure about INSERT)" the data in that table?
If you refresh or close and reopen then those "#Deleted" will disappear.
No, the table is closed, but if I try to modify some records, I get a write conflict error and only I am working with this database
It is very rare
Not sure if this article will help. http://support.microsoft.com/kb/128809
Did you try to re-linked the tables?
Yes, I tried to re-linked the tables and even reinstall office but with the same result.
In other PC´s works perfectly, just fails in mine
It is strange that you the only one has the issue.
Does the linked table has an unique key? or did you choose what you think is unique?