The culprit was a BigInt field type that is used in a clustered index.
Thanks again Brendan...
--
Kevin Backmann


"Kevin B" wrote:

I am connecting via ODBC to a number of tables in a database, located on an
SQL server. One of the tables that I’m linking to is a table that is updated
automatically via DTS with the update kicked off by a VB script.

On the Access side, if I view this table all I see are #Deleted flags in all
fields, even though there is data in the table if I view it from SQL
Enterprise Manager. All other ODBC linked tables display data correctly.

If done a refresh links in Access, removed and reestablished the link to the
table, and that has not rectified the problem. If I run a query, report, or
view the table through a form in Access all I get is #Deleted. However, if I
export this table from Access to Excel I get all of my records exported.

Anyone out there encounter this problem before, or is there something I’ve
overlooked?

Thanks ahead of time.

--
Kevin Backmann