SQL Server

[Sean H]

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?

 

[Kevin3NF]

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

 

[Graham R Seach]

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)

 

[Sylvain Lafontaine]

This Access database is big before or after compaction?