No, the provider can't be changed at runtime. Why not create another
connection which uses ODBC and use this if Jet 4 isn't installed?

Julian Skinner
Technical Editor
Wrox Press
http://www.wrox.com
julians@w...


-----Original Message-----
From: Philip.Ware [mailto:Philip.Ware@e...]
Sent: Thursday, June 15, 2000 4:41 PM
To: professional vb
Subject: [pro_vb] Re: Data Enviroment


No, basically I want to change the provider setting of the data enviroment
at run time...

but it doesnt allow me to do this.

Once the provider is selected at design time, your cant change it...

or Am I doing something silly and this is possible?

Phil.


> -----Original Message-----
> If the mdb was created with Access 2000 it has a different 
> format and it won't be recognized.