I've heard through various sources that Access has problems handling multiple users. Unfortunately I heard this after I created a database and it crashed a file server when a number of users attempted to use the database.
It is a bit difficult for me to believe that 10 users could bring a 1 GHz file server to its knees but this is what I'm being told. I'm hoping that someone on this forum can provide some insight.
The database is very small and simple. On the other hand the number of users can be very large. It can be as little as 10 users up to 100 users.
Database Description: 1 primary table with 30 fields. Depending on circumstances this table will have between 500 and 3000 records. This table will need to be updated. A number of other tables contain data which is used for selection in combo boxes. These tables occasionally need to be updated but this will be done by the DB Administrator.
During the first test I didn't split the database but for an upcoming test I will.
My question is, what other kinds of things should I be doing? What is the maximum number of users that can safely modify data at the same time?
I use a number of queries to extract data to be displayed on forms and subforms (hopefully in lieu of using print outs). I noticed that the queries were creating updatable dynasets. Since the forms don't allow editing I'm wondering if changing the query to create a snapshot would have an impact as well?
Hyperlinks are used to link to related documents, one per record. To my way of thinking this should not adversely impact the database. Should I take the hyperlinking out?
Thanks in advance for any assistance.
It is a bit difficult for me to believe that 10 users could bring a 1 GHz file server to its knees but this is what I'm being told. I'm hoping that someone on this forum can provide some insight.
The database is very small and simple. On the other hand the number of users can be very large. It can be as little as 10 users up to 100 users.
Database Description: 1 primary table with 30 fields. Depending on circumstances this table will have between 500 and 3000 records. This table will need to be updated. A number of other tables contain data which is used for selection in combo boxes. These tables occasionally need to be updated but this will be done by the DB Administrator.
During the first test I didn't split the database but for an upcoming test I will.
My question is, what other kinds of things should I be doing? What is the maximum number of users that can safely modify data at the same time?
I use a number of queries to extract data to be displayed on forms and subforms (hopefully in lieu of using print outs). I noticed that the queries were creating updatable dynasets. Since the forms don't allow editing I'm wondering if changing the query to create a snapshot would have an impact as well?
Hyperlinks are used to link to related documents, one per record. To my way of thinking this should not adversely impact the database. Should I take the hyperlinking out?
Thanks in advance for any assistance.