Using MS SQL 2000 with Access

  • Thread starter Thread starter Andy Levy
  • Start date Start date
A

Andy Levy

Hi

I have an access database on my win2k computer.

I would like to install MS SQL Server 2000 onto my win2k computer and import
all the tables into that database - and have all the tables linked to my
access mdb file from ms-sql.

Im completely baffled about which licence i need to buy. I have MS Access
on a few other computers around the office which i am also going to put the
Access front end on - to link to the tables in the MSSQL database. Do i
need just a single processor licence as the server software is only running
on one computer - or do i need a separate CAL for each computer connected to
it.

Many thanks

AL
 
A processor license is overkill for a "few" users. Assuming you really want
SQL Server instead of MSDE, it is probably cheaper to buy SQL Server in Per
seat or connection (whatever its called) mode. At some point as the user
count increases, it becomes cheaper to get the processor license, but that
number is pretty high.

More at:
http://www.microsoft.com/sql/howtobuy/default.asp

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
 
Does that mean - if two computers are running MS Access - and are
retrieving/ inserting data into the database held on MS SQL - then those two
computers act as devices? I have checked the price for this - and it is
about $5000, way beyond our budget - am i seeing right?


Many thanks
 
Andy Levy said:
Does that mean - if two computers are running MS Access - and are
retrieving/ inserting data into the database held on MS SQL - then those two
computers act as devices?
Click to expand...

No..the two users are considered clients. Why would you consider a user a
devices?

That pricing page is quite clear:

So, you are looking at about $146 per user.

On the link of

http://www.microsoft.com/sql/howtobuy/default.asp

If you scroll you can see for a Server + User CALS (Client access license)
you get a price of

$2200 for 10 users. For 5 users you get $1500

However, do be aware that you get a free version of sql server on every
office cd, and it works for 5 users. So, in fact, if you only plan to have 5
or 6 users...you can do it for zero cost..as you already have the office cd.
This version of sql server included with office is of course designed to be
used with ms-access. And, you can actually run more then 5 users...and it
just slows down..hoping you go out and purchase sql server. Note that this
engine is 100% compatible with sql server.

And, I believe the personal edition of sql for development is only $50 (but,
as mentioned...you get a free one on the office cd anyway).
 
And, I believe the personal edition of sql for development is only $50
(but,
as mentioned...you get a free one on the office cd anyway).
Click to expand...

I may be wrong, but I don't think you can legally use the developer version
for a production database.

Also, Andy...please be aware that the MSDE version on the Office CD does not
have the client tools that the other versions have.

A good whitepaper on versions is here:
http://www.microsoft.com/sql/techinfo/planning/SQLResKChooseEd.asp

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
 
Kevin3NF said:
I may be wrong, but I don't think you can legally use the developer version
for a production database.
Click to expand...

No...and I was not hinting that one should try and do this. (my ONLY point
here is that the tools and getting into sql server is very easy.
Also, Andy...please be aware that the MSDE version on the Office CD does not
have the client tools that the other versions have.
Click to expand...

Actually, what you can do is download the trial edition of sql server. While
the server expires..all of the tools like the Enterprise Manager and the
query analyser DO NOT expire. And, you don't even need windows 2000 or
latter. (those tools and the desktop engine install on win98 boxes if you
want).

So, essentially, if you have the office CD, then you can get the sql server
tools for free via the free trial. The end result is all of the tools that
sql server has...and this can all be done legally at no cost!
 
Back
Top