Requirements

[oliver_twistor]

Is there any specific software one has to use to be able to use SQL in Visual Basic .NET? I have Visual Basic .NET and Access 2000. Do I need anything else? //OT

[Mike Dimmick]

Nope, you have all you need. See the documentation on OleDbConnection, OleDbCommand, OleDbDataAdapter, OleDbDataReader etc. Note that the .NET Framework requires a minimum of MDAC 2.6 for the SQL Server data provider, but this isn't applicable in your case. It's probably not a bad idea to use that version, though.

[oliver_twistor]

Thanks! What is MDAC? //OT

[Teo]

MDAC is Microsoft Data Access Components. Yo can find it at http://msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28001860 For accessing MS Access databases, I have used the ODBC Data provider, which is faster. You can find more information at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconadonetproviders.asp Teo