[dba-SQLServer] Access limitations

jwcolby jwcolby at colbyconsulting.com
Thu Mar 20 20:22:33 CDT 2008


I have a database with about a gig of data.  However I broke it down into
several back ends because it is subject to corruptions and having it broken
down allows compacting / repairing just the corrupted be.  I have about
25-40 users in it every day.   


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Paul
Nielsen
Sent: Thursday, March 20, 2008 5:37 PM
To: 'Discussion concerning MS SQL Server'
Subject: [dba-SQLServer] Access limitations

As a SQL Server only guy, I'm unfamiliar with how far you can scale Access
today and still expect it to behave well and be stable. But this group might
know. How large can an Access database become before you begin to feel
nervous? And how many concurrent users? Assume you have great hardware and a
networking infrastructure. 

-Paul 

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list