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?
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?