By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,996 Members | 1,179 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,996 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.