Hello Chad.
Here at Rice we use Access for a lot of our simple sites. We have some DBs
hold over 60,000 (yes, thousand) records with no problems. Our user load is
low on these though, only 3-4 people working with them at any given moment.
We do have some that have about 10-20 thousand records that only viewable to
people on the web, just used for reporting. Sorry, no stats on usage, but no
complaints either.
Personally, I only use SQL. It is fast and flexible for developing,
especially if you are doing it remotely (Enterprise Manager works great for
me). Granted, I am not nearly as sophisticated as some of the people here,
but our stuff does the job, pretty much with little or no problems.
-Gary
> -----Original Message-----
> From: Chad [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 30, 2000 12:05 PM
> To: [EMAIL PROTECTED]
> Subject: MS Access V.S. SQL
>
>
> 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=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.