Problem with Data Bound Forms?

R

rfrost

Is it true that if table(s) are bound to forms that you will have concurrency
problems and multiple people are updating rows in the table? If so does
anyone have a recommended solution?

Thanks
 
A

Allen Browne

The statement is not true across the board.

Access is a multi-user database, so it does support multiple users
editing/adding simultaneously. You have several choices you can adopt,
including exclusive use, table-level locking, editing locks (page level),
editing locks (record level), and optimistic locking (page level, or record
level). Read up on those choices, and begin at:
Tools | Options | Advanced
In general, optimistic locking is the standard, and page-level is the faster
if suitable.

Additionally, read up on splitting the database into frontend and backend.
Starting point:
http://allenbrowne.com/ser-01.html
There is a wizard to help:
Tools | Database Utilities | Splitter
 
Top