J
Jeff
Hi All
Any help with these questions would be much appreciated - thanks in advance
for any assistance you can provide and if you need any more details please
let me know.
Jeff
I have made multi-user Access database with the back end (data) part of the
database sitting on a network drive of a LAN - with about 10 or more front
end Access database files sitting on desktops. I have linked the tables
from the back end file into each of the front end files. The system will be
used to track campaign related sales activities for a group of about 10
users - with an average of between 100 and 500 records per campaign and
about a hundred campaigns a year. I will need to have concurrent and
efficient access to the system by all 10 users. I am trying to launch this
tomorrow and I started to wonder if Access even supports this many users and
what the data limitations with Access are. My questions are these:
1. Does Microsoft Access work well with a multi-user setup as I have
described and is there a limit to the number of concurrent users?
2. With the level of data I have described will Access support this much
activity and how much data will Access support?
3. Will I have a problem with speed or efficiency setting things up like
this with an Access Database or should I store the data in an SQL database
instead?
3. If I use a SQL database can I simply port my table structure over and
link the tables to the front end Access files that I have created and will
that work any better?
4. Am I barking up the wrong tree entirely trying to use Access for
something like this when I should be doing something in another format or
language?
Thanks again for any input,
Jeff
Any help with these questions would be much appreciated - thanks in advance
for any assistance you can provide and if you need any more details please
let me know.
Jeff
I have made multi-user Access database with the back end (data) part of the
database sitting on a network drive of a LAN - with about 10 or more front
end Access database files sitting on desktops. I have linked the tables
from the back end file into each of the front end files. The system will be
used to track campaign related sales activities for a group of about 10
users - with an average of between 100 and 500 records per campaign and
about a hundred campaigns a year. I will need to have concurrent and
efficient access to the system by all 10 users. I am trying to launch this
tomorrow and I started to wonder if Access even supports this many users and
what the data limitations with Access are. My questions are these:
1. Does Microsoft Access work well with a multi-user setup as I have
described and is there a limit to the number of concurrent users?
2. With the level of data I have described will Access support this much
activity and how much data will Access support?
3. Will I have a problem with speed or efficiency setting things up like
this with an Access Database or should I store the data in an SQL database
instead?
3. If I use a SQL database can I simply port my table structure over and
link the tables to the front end Access files that I have created and will
that work any better?
4. Am I barking up the wrong tree entirely trying to use Access for
something like this when I should be doing something in another format or
language?
Thanks again for any input,
Jeff