I need to know the right code for the provider for access 2000.
I know the right code for access 97 is

.Provider = "Microsoft.Jet.OLEDB.3.51"

I know the driver is 3.6 for access 2000 but when i try to connect to database using

.Provider = "Microsoft.Jet.OLEDB.3.6"

I get a error saying the provider is not found.

BTW i got office 2000 installed.

PLease help