Hi,

Since we have issues with connectivity through OLE DB (using ADO) on certain installations (mostly windows hosts with win32 Office installed) we're trying to use UniDac in order to connect to a MS Access database in direct mode.

Delphi 10.4 and UniDac 10.3

We came across  a few issues:

1) As soon as we add a Data Type Mapping entry in TUniConnection component, we get an AV when trying to connect

2) Trying to use "SELECT @@IDENTITY" in a SQL returns an "Invalid token @" error.

3) Inserting a record in a table with linked foreign key returns an "Adding a row violates constraint" error. (Inserting a record without a value for the foreign key and then updating it works fine ??)

The above works fine if Direct connectivity is not used. (I have not tried this in win32 applications)

Is there possibly something I am missing or is 64bit Direct access problematic?

Thank you.