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

[Gilberto]

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

[ADezii]

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.