What are the advantages/disadvantages of SQL versus Access for serving as the
database? A 24/7 operation is desired that has security such that each location
can only access their own data. Some writing from these locations back to temp
tables would also be beneficial. The amount of data is not huge if that matters
(~20,000 records) and only about 300 hits a day would be expected. Users would
need to be able to do queries on their data and create reports.
I am sorry if this is the wrong place to post this. If there is a better forum
please point me there. I did figure that this group would have a much better
grasp on the situation than I. Thanks.