>Guys I'm very new to ADO and I've been reading tons of material and none seem to be helping. I have Access 2000 and a reference to ADO 2.1 Library and I keep getting a message that VB cannot find the specified provider. Can someone send me some sample code that connects to access and not SQL server
>
>Could it be becuase I have 2000. All the drivers are on the computer.
>Chris

Use the Jet.OLEDB.4.0 provider.