record lock property on the form

  • Thread starter Thread starter iccsi
  • Start date Start date
I

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,
 
iccsi said:
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?
Click to expand...

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

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,
 
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.
Click to expand...

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,
 
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.
Click to expand...

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 -
Click to expand...

Thanks millions,
 
Back
Top