Access Vs SQL

[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.

 

[Jack]

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.

 

[Jack]

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.

 

[Tony Toews]

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?

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