Solved Unable to find most recent example of a record (1 Viewer)

[Alc]

I try to run the following query and get a message "The Microsoft Access database engine stopped the process because you an another user are attempting to change the data at the dame time".


SELECT Max(tblActivityTracker_Import.TimeStamp) AS MaxOfTimeStamp
FROM tblActivityTracker_Import
WHERE (((tblActivityTracker_Import.[Action]) Like '*Macro completed*'));


First, I'm on my own PC and it's a local db. 100% sure than no other users are touching it.
Second, it's a select query, so no updates are being attempted.
Third, I can run all sorts of other queries on the same table with no problems.

I tried running a compact and repair, in case that helped, but it did nothing.

Has anyone come across this before?

 

[Pat Hartman]

Somewhere, you have a form/report/query that has locked the table. You are conflicting with yourself. Make sure ALL objects are closed and then try to run the query. You should not have a conflict.

 

[The_Doc_Man]

I see you have a time stamp field. By any chance does that table having that time stamp have any form with a timer that would touch it? Do you log something on a timer?

 

[Alc]

Thanks for the reply.
The data itself had been recorded via a few forms, but I'm looking at a copy of it, so it's not linked to anything.

I finally found out the cause, in case anyone else has the same problem.
When I sorted the table by the 'Action' field, six records showed up as '#####'. I checked and all the fields for those records showed the same. Deleting them and running a compact/repair removed the problem.