multiple users access same file at the same time?

[Guest]

We are in the process of creating an informational database in our office.
How can everyone in the office access this database at the same time? To
input, analyze, etc. Is there a network version?

 

[Rick B]

Each user would have their own MS Access application installed on their PC.

You would house the data (the back-end) on a server.

You would place a front-end on each user's PC. The front-end would have
links to the tables in the backend. Each front-end would also contain the
forms, queries, reports, etc.

Rick B

 

[Albert D. Kallal]

We are in the process of creating an informational database in our office.
How can everyone in the office access this database at the same time? To
input, analyze, etc. Is there a network version?

ms-access out of the box is network enabled, and does not requite any
additional licensing.

To make this reliably work, you should run the database splitter, as that
simply creates a data file, and then keep all of the application stuff in
another file. You set a link between the two, and then distribute the
application part (called the Front end) to each pc. This as a general rule
does NOT requite you to change any code at all, and takes less then two
minutes to split.

You can read about splitting here:

http://www.granite.ab.ca/access/splitapp.htm

 

[Guest]

Thank you! Do you know if multiple users can access the same file at the
same time too?

 

[Rick B]

Yes, but as mentioned, they would not each access the Front-End. Each
person would have their own front-end. This front-end file would be linked
to the back-end file with all the data.

Rick B