Multi-user access

[ppons]

I have a MS Access 2003 SP3 Data base that it is already set up with advanced
options setting to be shared, edited record locking, and enable DDE refresh.
How can I set this database to have multi-user accessing the DB (I believe I
have set this correctly), dynamic refresh, and when a record it’s been in use
by another user.

 

[golfinray]

You need to split your database. All the tables would comprise the backend
(BE) and reside on your LAN. The queries, forms, reports would be copied to
each users machine. See www.allenbrowne.com for details

 

[Arvin Meyer MVP]

A record being edited always is locked. Try using NoLocks if you are getting
record locking conflicts. It releases much quicker.

Always split your database in a multi-user environment, with a separate
front-end copy on each user's workstation, linked to a back-end on a server.