Hi Jason,

I'm using .Net 4.6.    It seems to be an issue with the ODBC driver.   I'm running WIndows 11, Version 22H2, Visual Studio 2019, Version 16.11.23

I'm able to access the Detail and SubClientStateInfo table for all clients.    When I try to access Detail-SubClientInfo , I get the error:

DataSource.Error: The table has no visible columns and cannot be queried.
Details:
2376-Detail-SubClientInfo

When I try to access EFilings, i get the error:

DataSource.Error: ERROR [HY000] [Lacerte][CLIDSI] (90) Unhandled managed exception caught: System.BadImageFormatException: This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded. (Exception from HRESULT: 0x8013101B) (Stack Trace: at Interop.ClientDataAccess.ITableAccess.MoveToNextRow()
at f.MoveToNextRow()
at Simba.CLIDSI.CLIDSIResultSet.Move(CLIDSIResultSet* , DSIDirection in_direction, Int64 in_offset))

All of this can be duplicated by using Microsoft Excel for Office 365, Version 2301 and accessing the tables via ODBC.

Fortunately, the data I need is in the client Detail table, but it would be nice to access all the tables.

Again, I really appreciate your assistance.

Regards,

Rick Kamp