Access vs. SQL

Webster01

Registered User.
Local time
Today, 20:01
Joined
Mar 25, 2002
Messages
15
I have been using Access for clinic visit records in a medical clinic. This has been performed on a single computer. I am planning on expanding this capability to record information from the exam rooms and will be setting up a sever and multiple work stations. I will also have more than one user at a time. My question is this,: Is it necessary to have this database converted to a SQL database or is Access alone a sufficient program to load onto a server and bring up the program in each exam room as needed? I do not anticipate more than 20 work stations or more than five people accessing the database at any one time. Thanks.
 
Access is capable to handle it, and run it. however, it would probably run faster and smoother if some of the database was converted to sql and ran on a sql server.
 
Access can handle that number of users and that number of active users depending on your network capabilities. If you don't have AT LEAST at 10 Mbit backbone, you might want to hesitate. And 100 Mbit would be better.

Also, Access, if it is going to be shared, will put quite a data load on its supporting network. Make sure you coordinate your setup with your network admin. Also, you might have data control issues that require special permissions on the shared directory.

SQL Server is nicer to your network than Access by itself, but adds its own share of issues. This is definitely a case where you want to do some reading (for instance, by searching this forum for "SQL Server") to see if any topics are relevant.
 
Thanks for the info. I will check out the "SQL issues"
 

Users who are viewing this thread

Back
Top Bottom