record lock property on the form

[iccsi]

I use unbound form and record locks property is No locks.
My drop down list row link to queries.

I get message that the table is locked when I try to modify the table.

My question is if form is no locks and drop down box links to query,
not table.

Does it make sense that the table is locked to modify structure,
because no one can edit the table?


Your information is great appreciated,

 

[Arvin Meyer [MVP]]

I use unbound form and record locks property is No locks.
My drop down list row link to queries.

I get message that the table is locked when I try to modify the table.

My question is if form is no locks and drop down box links to query,
not table.

Does it make sense that the table is locked to modify structure,
because no one can edit the table?

Only 1 user can be in the database if a table structure is being modified.

 

[iccsi]

Only 1 user can be in the database if a table structure is being modified..

understood,
Does unbound drop down using queries still count using table?
I thought queryies are retrieve data when it is executed to lock
table.
I thought only bound controls lock tables.
Should it release the table after execute the query?


Your help is great appreciated,

 

[Arvin Meyer [MVP]]

It doesn't matter whether it's bound or not. As long as the tables are
linked, the data is locked while the query is run/opened. You could just
change the queries to connect and open an exterior database, like:

SELECT *
FROM [C:\FolderName\Data.mdb].tblWhatever;

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Only 1 user can be in the database if a table structure is being modified.

understood,
Does unbound drop down using queries still count using table?
I thought queryies are retrieve data when it is executed to lock
table.
I thought only bound controls lock tables.
Should it release the table after execute the query?


Your help is great appreciated,

 

[iccsi]

It doesn't matter whether it's bound or not. As long as the tables are
linked, the data is locked while the query is run/opened. You could just
change the queries to connect and open an exterior database, like:

SELECT  *
FROM [C:\FolderName\Data.mdb].tblWhatever;

--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com

Only 1 user can be in the database if a table structure is being modified.

understood,
Does unbound drop down using queries still count using table?
I thought queryies are retrieve data when it is executed to lock
table.
I thought only bound controls lock tables.
Should it release the table after execute the query?

Your help is great appreciated,- Hide quoted text -

- Show quoted text -

Thanks millions,