SQL Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that is getting quite large and I would like to set up an
SQL database to handle this. Do you have to purchase an SQL database from
microsoft or any other software/hardware? Also, where is the ODBC driver
located in order to update to the newest driver?
 
You can buy SQL Server from your favorite software vendor (www.cdw.com is
mine)

I would recommend setting it up on dedicated server hardware, but with no
more details than you have provided I can't offer much else....

Use MDAC 2.8 on your client machines and you should be fine.

How large is large?

--
Kevin Hill
President
3NF Consulting

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

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions
 
Office prof. 2000 ships with

I believe the office professional CD ships with the development version for use with Access. It’s in their somewhere. This version has most the features enabled. It doesn’t support multiple users as fast as the full blown version. However, I have never use MDBs and I would imagine that the development SQL server is faster. Even under a user load.
 
Sean,

MSDE 2000 is included on the CD from Office 2000 onwards. MSDE 2000 is a
cut-down version of SQL Server 2000 - and it's free! Check your CD.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
(Currently in Japan)
 
Back
Top