Lock Table errors

[coolgaff]

HI I am desperatly looking for help in being able to open my database on 3-5 pc's at the same time when it is opened on one pc I get lock errors and this one "The database engine could not lock table "sbs" (our db) because it is already in use by another person or process. Settings are for shared and edit record? any ideas?

Cheers

 

[theprez]

Make sure the database is not being opened exclusive. Also if the database automatically launches a form, this form is probably bringing everybody into the same record. If this is the case, try using a menu or switchboard that opens first. This way everybody isn't going to the same form, same record.