#DELETED on ODBC connection to SQLSeerver2005

[Guest]

I get #DELETED on all Rows in and Columns in an ODBC Connected table in
SQLServer2005. I built a Pass-Through Query and can see the Data Just fine.
The PK in the table is a BigInt. I'm on a XPPro SP2 Box using the latest
Access2003, MDAC 2.8 and JET4 SP8.

 

[Rick Brandt]

I get #DELETED on all Rows in and Columns in an ODBC Connected table
in SQLServer2005. I built a Pass-Through Query and can see the Data
Just fine. The PK in the table is a BigInt. I'm on a XPPro SP2 Box
using the latest Access2003, MDAC 2.8 and JET4 SP8.

Access doesn't properly recognize BigInts so that is the problem. If you
are in a position to change the PK to a different type then do so, otherwise
you might find that the problem is limited to looking directly at datasheets
and that if you use a form the problem won't occur.

Worst case would be to use passthroughs and do all edits via SQL statements
and/or stored procedures.

 

[Guest]

Access doesn't properly recognize BigInts so that is the problem. If you
are in a position to change the PK to a different type then do so, otherwise
you might find that the problem is limited to looking directly at datasheets
and that if you use a form the problem won't occur.

Worst case would be to use passthroughs and do all edits via SQL statements
and/or stored procedures.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Unfortunately, I can't change the DB design, I was looking for MS to solve this issue with a sp9 fix. >