Why doesn't my macro run?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top