modify backend table

[iccsi]

I got table exclusive opened by other user when I tried to add a new
field in the table.

It seems the backend application table is locked by a user.
I use SQL as row source of the dropdown box.
If I understand correctly, Access does not lock the table if I use
unbound form and SQL as row source.
I always use MyDropDownbox,Requery the dropdown box is visible.

Please let me know if I am wrong.

Are there way to work aroun for this?

Your help is great appreciated,

 

[Piet Linden]

I got table exclusive opened by other user when I tried to add a new
field in the table.

It seems the backend application table is locked by a user.
I use SQL as row source of the dropdown box.
If I understand correctly, Access does not lock the table if I use
unbound form and SQL as row source.
I always use MyDropDownbox,Requery the dropdown box is visible.

Please let me know if I am wrong.

Are there way to work aroun for this?

Your help is great appreciated,

Hmm... what part of "exclusive" did you miss? It means that you can't
modify the table - someone's using it. Kick them out and then modify
it once you've opened the database exclusively.

 

[John W. Vinson]

I got table exclusive opened by other user when I tried to add a new
field in the table.

Do you really mean "add a new field" - alter the basic structure of the table?
Of course you need exclusive access for that, since the other user will not be
able to use a table if its structure is unknown.

Or are you trying to add *a new record* or change the value of existing data
in a field in the table?

Context please!

 

[iccsi]

You need exclusive access to the table when modifying the table's design.
That means a table lock.  If anyone is updating, adding or deleting rows, you
can't get a table lock.

You may've heard that Access (Jet) doesn't lock the table when using an
unbound form and sql to do the update, add or delete.  It doesn't.  It locks
the row (or page) that's being updated, added or deleted, just like usinga
bound form.  This is a row (or page) lock.  That's a lower level lockthan a
table lock, but a lock that prevents other users from getting a table lock or
a row lock on the same row, or a page lock on the same page.

You can only modify the table when the other users aren't using it for
updates, adds and deletions, so you need to kick them out of the table - or
the database if that's the only way.  Or wait for them to go to lunch or home
for the day.

Chris
Microsoft MVP

Thanks millions for helping,