471,337 Members | 805 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,337 software developers and data experts.

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

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

Mar 5 '07 #1
1 3821
On Mar 5, 6:39 am, t...@broadbandexpress.co.za 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.

Mar 5 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by Berj | last post: by
6 posts views Thread by Hannu | last post: by
3 posts views Thread by Shane Suebsahakarn | last post: by
5 posts views Thread by Andy P via AccessMonster.com | last post: by
3 posts views Thread by Giuseppe D'Elia | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.