🚀 go-pugleaf

I need to know how to do this, and how to handle future changes to MDAC.

What I want is to check for the version of MDAC in the constructor of my
main form before the following statements:

  Catalog=Variant::CreateObject("ADOX.Catalog");
  Catalog.Exec(PropertySet("ActiveConnection") <<
                ("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="+AnsiString("Test.mdb")));


This code works fine, on my system (W2K), and in other functions, I can
easily extract data from any of the tables.  But my testing so far has only
been on my development machine, and I have a number of questions.

1) Am I right in expecting an error if my program is run on my sister's W98
machine if it's version of MDAC has not been updated?  This worry is what
makes me ask how I can test for this so that instead of an obscure error
message, I can advise the user to update their MDAC (MS' jet is part of
MDAC, right?).

2) Are versions of MDAC backward compatible, so a program that works with
the current version of it will also work with the next version of it?  Would
I have to alter the Provider value to take advantage of any backward
compatibility that is provided?  Or would I have to produce a new version of
the program every time there is an update to MDAC?

Cheers,

Ted