Problem when adding new Linked Table (from DEAR to MS Access) using DEVART ODBC
I have two linked tables already in the database. These were added in an earlier version of MS Access.
However, when I add another linked table it comes up with #Deleted# in every field and record.
I use the same ODBC driver and have the same linked Table in an Excel spreadsheet and it works fine.
Can someone please point me in the direction to troubleshoot this.