How to connect to an Access Database in MicroStation Connect

Could someone provide a VBA coding example for pulling a recordset from an Access 2016 (64 bit) database in MicroStation Connect?  The code that we are using works with the 32 bit versions of MicroStation and Access, but fails on a workstation with the 64 bit versions of MicroStation and Access.

  • Hi Rob,

    Rob Harris WSDOT said:
    The code that we are using works with the 32 bit versions of MicroStation and Access

    What code do you use in 32bit version? There are more ways how to connect from VBA to a database or database file depending if ODBC, OLEDB or a native client is used and what library is referenced.

    Rob Harris WSDOT said:
    but fails on a workstation with the 64 bit versions of MicroStation and Access.

    What does it mean "fails"? Error details can help to find what is wrong (no proper library is registered in Windows, wrong configuration of 64bit ODBC data source, incompatibility between 32bit and 64bit versions of DB API etc.).

    With regards,

      Jan