Macro Results in Locking Error

[Jim Pockmire]

A form opens a table such that a macro that updates the table receeives a
"Locking" error. The form only needs read access to the table. Is there a
way to either lock the table or otherwise eliminate the error?

 

[Ken Snell]

Open the form in ReadOnly mode. This can be done in the fifth argument of
the DoCmd.OpenForm command.

 

[Jim Pockmire]

Ken,

It turns out that I have the table connected to a query for a drop down list
box. Opening the form in read only does not allow me to select a value from
the list. Is there a way to resolve this?

Jim

 

[Ken Snell]

Let's step back here....can you provide me with more details about the form,
what's on it, what its purpose is, when is the macro running, what is the
purpose of the macro, etc.? Let us see if perhaps a different approach to
what you're doing can be used before we get into major "workarounds" for the
problem.
Ken Snell
<MS ACCESS MVP>

 

[Jim Pockmire]

I think you are right about a different approach, which is the direction I
am heading. There are two parts to the form. One part is a table refresh
importing data from another database. The other part is a report input
screen. The drop down list is a customer ID box. If someone opens the list
box prior to doing the refresh, the locking error occurs. I can break this
into two forms, but I was trying to keep it in one.

Jim

 

[Ken Snell]

Sounds as if you're working towards a solution. Post back if you have
questions. Good luck.