Two users opening the same Access database (mdb) over the network at the same time, without locking the file

[tian]

Hi could someone hel me with this dillema. In my current network
setup, a certain Access Database(.mdb) File must be opened by two
different people at the same time.
At this moment in time if one person opens the specific file, another
person can't open the same time, because Access Locks the file in use.
How can I prevent Access from doing that and how can I allow two
different users to open the same file over a network at the same time?

TB

[storrboy]

On Mar 5, 6:39 am, [e-mail] wrote:

Hi could someone hel me with this dillema. In my current network
setup, a certain Access Database(.mdb) File must be opened by two
different people at the same time.
At this moment in time if one person opens the specific file, another
person can't open the same time, because Access Locks the file in use.
How can I prevent Access from doing that and how can I allow two
different users to open the same file over a network at the same time?

TB

Split the database into a front-end (FE) and a back-end (BE).
FE contains forms, reports, queries, macros, modules and *linked*
tables.
BE contains tables.
Place a copy of the FE on each workstation and link tables to BE.
Users must have read/write capabilities on the BE folder.
Ensure shortcuts to FE (if used) do not include switch for
OpenExclusive.