I am using Microsoft Access 2000 to create a rather large database(by my standards). The database will sit on my network. Up to 16 people could be using the databas at any given time. Will this pose a problem? I need the database to run flawlessly or as close to it as possible. I was considering breaking up the database into 3 and having only about 4-5 users at any given time. I know the database can handle the number of users on paper but I would rather have input from someone with real life experience. I don't want to take any risks!!!
Here are some specs on the size of the database...if that makes a difference.
It has a main form and about 4-5 subforms. There are about 400 records in the main form and each related subform contains about 60 records. When I complete a large query I am near the limit of 255 columns.