Access or SQL

[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

 

[Arvin Meyer]

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 constraints
TIA
Tony

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

 

[Guest]

Thanks Arvin useful inf
Tony