Deciding between Access and SQL Server

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

I need to know how to decided between Access and SQL
Server depending upon the size and usage of the
database. There used to be a formula out there somewhere
in which you could input expected parameters of your
database (i.e. # tables, # records, etc.) and it would
tell you whether or not your database should be in SQL
Server rather than Access. Is anyone else aware of that
formula, or have any suggestions on where I might find
it? Thank you. You can email me at
lead[remove this]@nhlgc.org
 
Since you gave us no info on your db, we can't offer much. I really don't
think there is an accurate formula for determining the exact point at which
you should upsize, other than when you have reached the technical limits of
Access (2GB file, 255+ users, etc.)

Feel free to post your specs so we can all throw an opinion out...:-)

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
Back
Top