Hi

Can anyone advise of the performance capabilites of Access Database, say, compared to SQL, for example, how much traffic and concurrent users it can take and how much information it can hold before SQL (for example) is required.

Help apprecieted.

Mattys

Hi Mattys,

Everything I have read says that Access can only handle 5 concurrent users. The database size limit is also 2 GB. The locking for multiple users is also much better on SQL Server.

So if you have the budget, and are worried about these 2 factors I would buy SQL Server.

Hope this helps,

John