Access Vs SQL

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

We're intending to upgrade our database at the company I
work for. We currently have an Access 97 database. My
question is: if we perform the upgrade to Access 2002 and
split the database to a back-end and a front-end, aren't
we going to have a Client Server Solution in this case? Or
it's better to use SQL? And why is SQL widely accepted
more than Access as a database solution?
You have to excuse me because my knowledge in Access is
not that great and I couldn't find the answer to this.

Second thing, is there any article that makes this
comparison between Access and SQL?

Thanks in advance for your help.
 
Thank you Kevin for your fast reply. Let me clarify some
points to you; we currently have SQL server installed that
handles our accounting database -correct me if I'm
mistaken-, this means that we don't have to assume any
extra charges to add our depatment database to the SQL
server. Or we need to get extra licenses to use SQL in the
back-end?
There are approximately 40-50 users who are using our
dept. database and they access it simultaneously from our
LAN or through Citrix Server on remote locations. I also
understand that there is a fair bit of learning if we want
to use the SQL solution.
Please tell me your opinion after you got a broader idea
of our assets and needs.

Thanks a lot.
 
I'm the wrong guy to ask about SQL Server licensing....:-)

With 40-50 simultaneous users, I would definitely consider bumping the
back-end to SQL Server, and the FE from an Access MDB to an ADP (Access Data
Project). That many users hitting a JET database engince makes me nervous,
from a corruption potential standpoint.

How large is the database you have now? How critical is it (how much data
can you afford to lose if the database corrupts beyond repair)? Is security
an issue? Is the current speed acceptable?

SQL Server is different from Access, depending on how you want to use it
(MDB vs. ADP)....either way there will be at least a little learning curve,
but in my opinion it is worth it.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/Newsgroups
 
Thanks Kevin. I will delve more into the SQL Server
licensing and will put what you said to me into
consideration. You were a great help.
 
Jack said:
We're intending to upgrade our database at the company I
work for. We currently have an Access 97 database. My
question is: if we perform the upgrade to Access 2002 and
split the database to a back-end and a front-end, aren't
we going to have a Client Server Solution in this case? Or
it's better to use SQL? And why is SQL widely accepted
more than Access as a database solution?
You have to excuse me because my knowledge in Access is
not that great and I couldn't find the answer to this.

Second thing, is there any article that makes this
comparison between Access and SQL?
Click to expand...

There can be a lot of working doing the upsizing. See the Upsizing
page at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top