#DELETED on ODBC connection to SQLSeerver2005

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Neil said:
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.
 
Rick Brandt said:
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. >
 
Back
Top