DAO 3.5/3.6

[Nairad]

We are currently upgrading our database deduplication software to cope with Access 2000 and Excel 97.

Our current software uses DAO 2.5/3.0, now we are aware that an upgrade to ADO would solve our problem but as a completely new product is on the cards, we are just looking for a quick upgrade.

The problem is, that when using DAO 3.6, Access 2000 is fine but Excel fails. Use DAO 3.5 and Excel is fine but it cannot connect to Access 2000. We suspect there is an issue with the data control. Has anyone a definitive answer?

[Clunietp]

You can use late binding to create both of the different libraries in the same project

    
    Dim dbExcel As Object
    Dim dbAxs As Object
    
    
    Set dbExcel = CreateObject("DAO.DBENGINE.35")
    Set dbAxs = CreateObject("DAO.DBENGINE.36")

Then you just have to code it manually and it should work.....

HTH

Tom