You also have to take care about stopping the work with the database for repair and compact!
When you use Access when there is a logged user in case of failure of the database it's impossible to repair the database! In your front end application its good to place an algoritm to close the front end applications of all users in case of failure!
It's the same thing when you want to modify the structure of your database!
If you expect to have large amount of data, it's good to use run SQL statements to the network database placing the results in the local machines! It's similar like a WEB Php or other programming interface passes the SQL to the database and obtain the result! Here the obtained result is better to be on the Local machines for better performance!
When You use action queries it's better to use as fast as possible queries. This diminues the number of concurrent users - the users who pass in the same time a query to the database!
Using the local machines and temporary tables installed there can diminue the charge of the network database and decrease the number of concurrent users!
You have to consider the limitations of Access:
Max number of tables: 2000
Max volume of a database: 2GB
Max number of Forms and so on!
And the interruption of the work of your colleages when you modify athe databse or only to repair it, it's also significant, but you can optimize this inconvenients by VB code!
It' s also important to think doing archiving of the information! For exemple the information of one year can be placed in one database, for the new year you open a new database, using the same front end!
In this cases you can place in the new database the active information from the past year!
IF there is a large amount of data your periods can be smaller then 1 year!
So this will be your application to collect and treat the information operatively! For strategicaly needs you have to use similar database and append the new records there! The information will be treated slowly with hours and not be available on all the network and for many users!
Have a good chance!
Sincerly Vladimir /PEB/