[AccessD] Re: Limitations of ADP/SQL

David,

If it is the full version of SQL Server, then it is the limits of SQL 
Server, which is pretty much disk space.  I think clustered servers for the 
database would be the next step up.  The ADP is simply the front end to it 
and is limited by the number of objects that it can contain, which I think 
is in the thousands.  And, the tables, views, stored procs, etc are not 
included in the limit since they reside on the server.

Robert

At 01:11 AM 02/07/2004 -0500, you wrote:
>Date: Fri, 02 Jul 2004 05:29:03 +1200
>From: David Emerson <davide at dalyn.co.nz>
>Subject: [AccessD] Limitations of ADP/SQL
>To: accessd at databaseadvisors.com
>Message-ID: <5.2.0.9.0.20040702052645.00b3e958 at mail.dalyn.co.nz>
>Content-Type: text/plain; format=flowed; charset=us-ascii
>
>I have written an app for a company with an Access XP ADP F/E with an
>SQL2000 BE.  The company wants to know what the limitations are with this
>set up (how many records/how large can the data base get) and what would be
>the "next step up".
>
>Does anyone have any pointer for information?
>
>Regards
>
>David Emerson