How do i update 3 forms linked to 3 tables

[Guest]

I have 3 subforms linked to 3 tables, they are driven by 3 seperate queries.
When I try to update them from the open master form with a command button, i
get the following error message:

'The database engine could not lock table <name> because it is already in
use by another person or process. (Error 3211)'

How can I update these 3 queries with a button or command on the main form

Is there a way to temporarily Locking the tables so that I can run my queries.

 

[John Vinson]

I have 3 subforms linked to 3 tables, they are driven by 3 seperate queries.
When I try to update them from the open master form with a command button, i
get the following error message:

'The database engine could not lock table <name> because it is already in
use by another person or process. (Error 3211)'

How can I update these 3 queries with a button or command on the main form

Is there a way to temporarily Locking the tables so that I can run my queries.

What do youmean "driven by" as contrasted to "linked to"? Is there
some code on the form which updates tables when you open the form?
JUST opening a Form doesn't update anything, and shouldn't generate
this particular error.

My guess is that a) you have some code and b) it's attempting to
update a table which is already open on one of the forms; the "other
person or process" is the form itself.

John W. Vinson[MVP]

 

[Guest]

Hello John,

A fuller explanation.

the forms are for a user quiz (3 of the best)

I have 3 forms linked to 3 tables that are 'made' by 3 'make table' queries.
within each query is a random generator that picks a possible 10 locations
(by locationID) randomly from a master table of 1400 locations and offers a
set of 10 for each form via the 3 tables.

The background behind this is; they are 3 lists of 10 locations, and the
user has to guess a correct single addresse from a combobox to match the
'location' control field on each form. These 3 forms are placed on a single
Form. All works well, except I am now trying to create a mechanism whereby
the user can hit a button and requery the 3 tables via the queries. I hope
this makes sense and that you can help further.

regards

Eric