[dba-SQLServer] Access limitations

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





More information about the dba-SQLServer mailing list