I thought it would be simple and it may well be only I do not seem to be looking at the right objects.

I'm using VB6 and ADO (data environment 2.1 but it probably doesn't matter)

The reason I *think* I want to do this is to create a gui to allow the user to select a data source- like the ODBC datasource builder in control panel.

An application I have written using the
ConnectionString=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\myDB.mdb;Persist Security Info=False

works fine on my dev box which is NT4 and has Office 2000 installed.

On a client machine, which is say Win98 with Office97, I have to specify
ConnectionString=Provider=Microsoft.Jet.OLEDB.3.51;Data Source=c:\myDB.mdb;Persist Security Info=False

Which is all fairly OK by me. I just want to do it for the user (currently I store this in an ini file).

A lead on question is: Can we access some of the built in MS Access tools such as compact?

Perhaps the best answer to my questions would be if someone could direct me to the correct place in MSDN or anywhere else for that matter to get my answers.

I thought it would be straight forward....What am I missing?

Any help appreciated
Regards
Paul Lewis