Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL vs Access

0 views
Skip to first unread message

Terry

unread,
May 3, 2001, 7:42:11 PM5/3/01
to
Any input would be appreciated. Currently we have several Access databases (not
linked and thus causing double entry) that is accessed by one person who then
feeds about 300 users information extracted. Our future goal is to make the
information Web-accessible.

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.

0 new messages