Using these VBA commands on a query from local tables which returns only 105 records with 6 fields none of which are longer than 80 characters.
I think the mdb may be corrupted, but repair and compact makes no difference.
tables were originally imported from sql2019.
ODBC = "ODBC Database"
DSNConnection = "ODBC;DSN=ToPTSQL;UID=sa;PWxxxxx"
DoCmd.TransferDatabase acExport, ODBC, DSNConnection, acQuery, "OwnerQuery1", "Owner"
(This command works fine for several other tables and queries)