Access 2000 and Delphi 7

[Karen99]

Hi

I have a program that was developed in D5. What it does is the user can select a .mdb file to export data to and the the applicaton did some tests and exported the data from Oracle to the Access db. The app used MSAcess (native driver). I have upgraded the app to Delphi 7. I am not sure which Access version was used previously. Probably an earlier one than Access 2000.

Now, for some reason it does not work anymore. I have read somewhere that MSAccess does not work with Access 2000. If that is the case, how do I work around it. I can not setup an ODBC connection, because the user must select the Access db at runtime. Or can I setup an ODBC connection at runtime ?

Please help !!
Karen

 

[Griffyn]

I don't know how complex the database coding is, but if you change to the ADO components, you'll be able to specify the access database name at runtime.