Jim Lawrence
accessd at shaw.ca
Thu Mar 20 23:16:48 CDT 2008
Paul: If you use a combination of Access FE, ADO-OLE and a nice SQL server as a BE, a couple hundred users with 100,000 rows is not a stretch. Jim -----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 2: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