 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / SQL Server / ADP / July 2005SQL Server
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?  SignatureKevin 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 >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? 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) --------------------------- >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? This Access database is big before or after compaction? SignatureSylvain Lafontaine, ing. MVP - Technologies Virtual-PC E-mail: http://cerbermail.com/?QugbLEWINF >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? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.