Record Locking Error 3009

[amerfeld]

Hi All:

I have a form that at certain times, requeries tables to update pricing. My problem, I have now found, is if users access this form at the same time (even if they are accessing different records) the second user will get error message 3009: "You tried to lock table while opening it, but the table cannot be locked because it is currently in use. Wait a moment..." when requery code runs.

Does anyone have any recommendation on how to handle this? Anyway around this? I am at the end of a very long creation process and hope I don't have to reinvent the wheel. I'll hold my breath! Thanks!

ps I have record-level locking set as well as edited-record record locking

 

[Len Boorman]

Could you arrange for the table update query to run at a quiet period.

I have set situations where I needed to run a daily update. I wanted to run this between 08:00 and 08:15.

I set a hidden field in teh opening ford that contained the current time.

Then an On Open Event

If Time <08:15 then
Docmd.quit
End if

Basically this shut every body out unti 08:15 every morning. I ran the update query from my own interface that used linked tables

Len Bl