[dba-SQLServer] Access limitations

Robert L. Stewart robert at webedb.com
Mon Mar 24 10:12:10 CDT 2008


Paul,

Personally, 100 meg is the limit I have defined. If it got that
big, I moved it to the MSDE.  Now, I do not use Jet for a
database at all. I stick strictly with SQL 2005 of some flavor.

Robert

At 11:30 PM 3/20/2008, you wrote:
>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





More information about the dba-SQLServer mailing list