How many users can access an Access Program?

[Guest]

I am designing a program that will require multiuser access on a network
server environment. Approximately about 5-10 users.

Are there any special programming requirement needed.

 

[Rick B]

Nope.

Just make sure to split your database and distribute the front-ends to the
various users. The abck-end should reside on your server.

10 or 20 users should run fine.

Rick B

 

[Guest]

Thank you for your reply.

Could you explain spliting the database in two front-end and back-end.

The program is being by about 5 call operators to log client calls on a
daily bassis.

 

[Josh]

Make sure you put your database (the *.MDB) file on the server and
install access on the clients located on your network. The server does
not need access

 

[Joseph Meehan]

Thank you for your reply.

Could you explain spliting the database in two front-end and back-end.

You want to put all the data in one database located on the server and
all the queries, forms and reports in a database located on each user's
machine and linked to the one on the server. It just works a lot better
that way.

The help file has the following instructions in version XP.

Split an Access database

You can split a Microsoft Access database into two files: one that contains
the tables and one that contains the queries, forms, reports, macros,
modules, and shortcuts to data access pages. This way, users who need to
access the data can customize their own forms, reports, pages, and other
objects while maintaining a single source of data on the network.

On the Tools menu, point to Database Utilities, and then click Database
Splitter.

Follow the instructions in the Database Splitter Wizard dialog boxes.