I've linked to a SQL table, using an ODBC link I use frequently but this particular table shows all the fields with a value of "Deleted". Any suggestions on how to access my table?
I've linked to a SQL table, using an ODBC link I use frequently but this particular table shows all the fields with a value of "Deleted". Any suggestions on how to access my table?
if the table is open, then records deleted, it will show deleted.
if you close the table, then open, it should only show normal records.
if not, refresh the link.
Facing exactly the same problem and still haven't found any solution to it yet.
Have you managed to solve it?
Some links that could possibly help you.
https://learn.microsoft.com/en-us/of...-table-deleted
https://support.microsoft.com/en-us/...0-9851042e0024
Maybe the structure of the table has been changed, for instance: a field is removed or changed place using SSMS. I this case SQL server deletes the old table and recreates it, data included. In this case: delete the old link and relink the newly created table.