I am trying to run a macro on my database and it keeps coming up with the
following message:

'The database has been placed in a state by user 'admin' on machine 'ukpms'
that prevents it from being opened or locked'

Have some temporary lock files been created somewhere if a user has crashed
out from the database??

That's all I could think of being an access novice!

Yes. Whenever a user opens a database, Access creates a lock file in the
same in the same folder as the database file, which has the same name as
the database file, with extension .ldb. Access is supposed to delete the
lock file when the (last) user exits the database, but obviously fails
to do so if it crashes, so the lock file stays there! Try to delete it
manually (from My Computer or Windows Explorer).

HTH,
Nikos

Jindy Singh wrote:
> I am trying to run a macro on my database and it keeps coming up with the
> following message:
>
> 'The database has been placed in a state by user 'admin' on machine 'ukpms'
> that prevents it from being opened or locked'
>
> Have some temporary lock files been created somewhere if a user has crashed
> out from the database??
>
> That's all I could think of being an access novice!