Run-time error 3211 - New User

[PHolmes]

I am trying to open a report but i keep getting a run-time error 3211 "The database engine could'nt lock table as its already is use by another person or process". How do i get Access to wait, should this actually be the problem?

 

[gilly]

I have had a similar problem and found a couple of ways to tell access to pause via a line script placed at the top of your module under the Option Explicit.

Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

Then type for example "sleep (5000)" to pause for 5 seconds before continuing. If this doesn't work then you most likely have another problem