You're right, Gregory -- the question is not so much the number of records
(10,000 can EASILY be handled by Access), but more what do you expect in
terms of number of INSERTS, UPDATEs and DELETEs during a given period of
time.
I've found, however, that Access can be a great solution in some
circumstances. For example, I've got a CF-based CRM application, running on
Access 2k (139mb), that easily supports 15 concurrent users who bang on it
pretty good 8 hours a day -- lots of INSERTS and UPDATES. The application is
not only fast, but we've had no data integrity issues either. Granted, the
application is on an Intranet -- so I know traffic won't dramatically change
overnight. I will soon be upsizing the application to SQL Server because I
AM concerned about future activity, not because the application doesn't
perform well today.
I know it is politically incorrect to admit that you use Access, but it is
an inexpensive solution that can be a good fit in some situations -- plus it
is relatively easy to upsize to SQL Server when you can justify the cost.
Chris Michl
----- Original Message -----
From: "Gregory Harris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 30, 2000 12:26 PM
Subject: Re: MS Access V.S. SQL
Having 10,000 records is one thing, how often, and how many people are going
to be accessing them? If it's anymore than "a few", then you better go to
SQL Server. It's really that simple....
Gregory Harris
Los Angeles Information Technology Agency (ITA)
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 08/30 10:04 AM >>>
How many records can MS Access handle safely? Im looking at a project that
may be around 10,000 Records.
Are there other specific database needs that demand making the leap to a
SQL server?
Thanks
Chad
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
