Differences between Access and SQL... why 'upsize'?? 1

[GComyn]

I'm trying to put together a proposal for my boss that will show why we should 'upsize' our database to SQL Server.

Right now, I've got about 10 or 20 databases that are over 50,000 records (most over 150,000) and they are getting bigger by 1,000 records a week (some are getting larger by 40,000 a month).

I've been looking for documentation as to why SQL is better able to handle the information than Access (we use 97 right now, but will be changing to 2000 by the end of the year [yeah.. my company is a little slow....]). If anyone can point me to documentation about the relative benefits of SQL Server over Access, I'd appreciate it.

GComyn

 

[tlbroadbent]

Check the article, "When to upsize a Microsoft Access database to Microsoft SQL Server" at Microsoft.com.

http://msdn.microsoft.com/library/en-us/off2000/html/acconWhenToUpsizeMDBtoSQLServer.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[GComyn]

Thanks, tlbroadbent!!!

That is exactly what I was looking for... but could never find it!!

GComyn