Adding new record to a multiuser database and not locking databas.

M

mbc28

How do I create a database that would not lock tables when adding new record
to a multiuser database on the network.
 
J

John Vinson

How do I create a database that would not lock tables when adding new record
to a multiuser database on the network.
Click to expand...

ummm... open Access. Use its default settings (which are single record
optimistic locking). What problem are you having? What are the current
settings on the Advanced tab under Tools... Options?

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Lock File .LACCDB / Now shows as a notepad file 0
Proposal template with removable sections 0
Record Locking Multiuser 1
Multiuser Access 2
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
sqlite-odbc write conflict 2
How to keep report from locking other users out 4
MultiUser Issues with Access2002 - Errors 3343, Invalid SQL,214721 7

Top