🚀 go-pugleaf

X-Orig-MsgId: <84b8aq$19v$2@news1.bu.edu>

Your in the SQL Server newsgroup they'll all say SQL.... It's your
decision just keep in mind it's a lot harder to make changes in SQL.
I have been using Access as the development tool and when everything
is pretty much set I use the upsizing wizard to move my stuff onto
the SQL Server.  Although Access is pretty fast I have noticed
performance loss in small databases after being moved to SQL.  You
also can publish data from an Access database on the internet.  The
procedure and tools (ASP) are the same as with SQL Server and remember
the SQL Server internet connector license is very expensive.  We are
an educational institution and it still costs $1800 per processor.  
I think the corporate price is close to 10k.  You can do the same
thing with Access for free. 

As I say your decision but my suggestion use Access you can always
upsize it later.  It's a lot more difficult to go the other way.

Take care,

Tom


best_3-d <best_3-d@email.msn.com> wrote:
: What criteria should I use to decide if Access2000 or sql server 7 would be
: a better selection for a database? The application will hold initially
: information for approx 2000 clients. The number of tables will be approx 25.
: The application will run on the desktop and internet. Growth is expected but
: ,  presently, it is undetermined how fast it will grow.