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

Can a DB be used/modified by different users at the same time???

100+
P: 135
Hello,

I have created my first DB which will be used by 5 different persons and will be accessed through the intranet. I was wondering if access allows to have the same DB to be open and modified at the same time by different users???

Is this possible??? Any ideas how can i achieve this??

Thanks,
Gilberto
Sep 20 '07 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,638
Hello,

I have created my first DB which will be used by 5 different persons and will be accessed through the intranet. I was wondering if access allows to have the same DB to be open and modified at the same time by different users???

Is this possible??? Any ideas how can i achieve this??

Thanks,
Gilberto
I was wondering if access allows to have the same DB to be open and modified at the same time by different users???
As Curly of the 3 Stooges would say, Certainly!
Is this possible??? Any ideas how can i achieve this??
  1. The best way to implement this would be a File-Server architecture in which all the Application Objects (Modules, Forms, Reports, Macros, Queries) reside on a Front End Database.
  2. The actual Data (Tables) resides on a Back End Database.
  3. The Front End Database physically 'Links' to the Tables residing on the Back End DB. This scheme allows Multi-user access since all Users would be accessing/modifying, etc. the same data (Back End Tables).
  4. Just a couple of side notes:
    1. Make sure that the following is set: Tools ==> Options ==> Advanced Tab ==> Default Open Mode = Shared.
    2. It is a good idea to set: Tools ==> Options ==> Advanced ==> Check Open databases using record-level locking.
  5. This should provide a good foundation for what you wish to accomplish.
Sep 20 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.