Mystifying Repopulation of Table
Posted on 2014-01-09
I was asked to clear some data from an existing Access 2003 (mdb) database. I wrote a query to delete the records from the table. I was in the backend of a split database. Files were not linked. I ran the delete query and records were deleted. After a couple of minutes, I opened the table and the records were back. As a matter of fact, I could delete the records with the query, open the table and watch it repopulate. I could not find an autoexec macro which would cause this (of course that would only matter if I closed and reopened the database). There was zero code in the database. Anyone have any ideas?