Access or SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there anywhere that gives advice on the maximum size of an Access Database before you should consider a full blown SQL system. Like how many reords and how many users
I am helping develop a system and we would like some idea of the constraint
TI
Tony
 
Tony Williams said:
Is there anywhere that gives advice on the maximum size of an Access
Click to expand...
Database before you should consider a full blown SQL system. Like how many
reords and how many users?
I am helping develop a system and we would like some idea of the constraints
TIA
Tony
Click to expand...

I start to look at a server based system when there is a lot of activity,
not necessarily numbers of users or records. The smallest SQL-Server system
I've built only had 12 users, but they were manipulating large amounts of
data. Usually, I start looking at a server-based solution with 50 users
and/or several hundred MB of data.

I've seen Microsoft recommendations with as few as 20 users and 100 MB of
data, but you have to remember that they make far more money selling
SQL-Server.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top