Paul Nielsen
pauln at sqlserverbible.com
Thu Mar 20 23:17:54 CDT 2008
Sure, but like I just told Arthur, that's not Access, that's SQL Server with a front-end. I've pushed SQL Server to several thousand users and hundreds of millions of rows in Tb+ databases (at 35K tps). But that doesn't test Access. My question is how far can you safely push Access with just the jet engine? It is interesting though that the answers keep coming back as Access+SQL server. Is that due to the demographics of this group, or is the Access developer community moving beyond Access as a BE? -Paul -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Thursday, March 20, 2008 10:17 PM To: 'Discussion concerning MS SQL Server' Subject: Re: [dba-SQLServer] Access limitations 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com __________ NOD32 2965 (20080320) Information __________ This message was checked by NOD32 antivirus system. http://www.eset.com