Jim Lawrence
accessd at shaw.ca
Thu Mar 20 23:28:24 CDT 2008
Hi Paul: The Jet-Engine is fine but it is very limited (2 GB maximum) for the data usage. Near the maximum size limits thing start to fall apart. The last couple of Access apps I have put together I just dropped MDB and replace it with SQL Express/ADO-OLE. (MySQL and PostgreSQL are other excellent choices.) Once had a Access DB with one MS SQL DB and 2 Oracle DBs attached... try that with anything else... up and running in a couple of hours) 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 8:54 PM To: 'Discussion concerning MS SQL Server' Subject: Re: [dba-SQLServer] Access limitations Hi Arthur, I agree ADP is great. But it's a front-end to SQL Server so you're really testing SQL Server (which regularly handles multi-terabyte databases and thousands of concurrent connections), not the Jet Engine. I'm wondering how far you can push the Jet engine. In your use of ADP, did you use a database abstraction layer in SQL Server (all procs all the time)? Or ad-hoc SQL? -Paul -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Thursday, March 20, 2008 9:39 PM To: Discussion concerning MS SQL Server Subject: Re: [dba-SQLServer] Access limitations I think that I was one of the earliest adopters of the ADP approach, which lets you talk directly to SQL Server from Access. In that scenario, all that lives in Access are the forms and reports. So you get the best of both worlds -- RAD in Access and performance and scalability in SQL Server. In the biggest such app I did, I had over 70 simultaneous users hitting a SQL db that was about 3.5 gigs. In a test scenario, I had an Access ADP hitting a 20 gig db with no issues. A. -----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 _______________________________________________ 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com