Jet problems?

[elziko]

When executing this:
conmdb.Open ("Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & Environ("WinDir&quot & "\blankreport.mdb&quot

I get this:
3706 Provider cannot be found. It may not be properly installed.

This is an installation running on a Win2K machine. What do I need to install? I've tried installing Jet4 Sp3 but that doesn't help. What next?

Many thanks,

elziko

 

[woyler]

If you do not have that driver installed, then you will get that error. Look in your data sources under control panel, to see which versions you have.

 

[woyler]

It is under administrative tools on win2k

 

[sdh]

no sure cos I don't use w2k but access 2000 I think uses
Microsoft.Jet.OLEDB.4
thats probably the only driver you have.
you will need to code
Provider=Microsoft.Jet.OLEDB.4.0

hope this helps
sdh
:

 

[elziko]

So, what I have gathered by trying to install Jet 3 and Jet 4 together is you cant do that. You also cant install 3 over 4.

The only way I can deal with this is to check which version is installed and use that provider?

Otherwise I'll have to create two seperate projects which use different versions?

What do I do about future versions. I could pull out the current version from the registry and then insert that directly in my ADO connection string, therefore future proofing my code.

Any thoughts or suggestions on this?

Many thanks,

elziko

 

[woyler]

No. Jet 3 will not work with newer versions of access. 4 will. If you use Jet 4 you can have one version and use it for new and old versions of access