Database locking

[Jon.N]

I have a database called 'Central.mdb'. This database contains a table called 'tblEmployees' and every employees name is stored in it.

'tblEmployees' is linked into other databases using the linked table manager. In the other databases combo boxes use the tblEmployees as their data source.

When someone selects a name from a combo box in a database the database called Central.mdb locks so that other users in other databases can't use a combo field that uses tblEmployees as its data source. Central.mdb doesn't get released until the person who locked it closes the form they were working on.

I have tried using SQL with the IN statement as the row source for the combo box, but still the locking problem is prevalent.

We are using Access 2002, office XP and Win2K server. Any help is gratefully received.

 

[llkhoutx]

Go to Tools|Options and check your record locking selections.

 

[Jon.N]

Sorry for taking so long to reply, I have been off-line and then on holiday for a few days.

Thanks for your reply, I had an idea my problem was something to do with how I have set the record locking but I was not sure. I am investigating my options.