| Brian Moran 2002-10-05, 9:06 pm |
| I don't have the KB handy, but I belive this will happen if the PK of the SQL table is a float datatype. Float is a non-exact number and SQL and ODBC basically translate the number differently. The numbers don't match so Access think the record has been deleted... change the data type to a precise value such as a decimal datatype and see if the problem goes away...
--
Brian Moran
SQL Server MVP
SQL Server Magazine Columnist
"Darin Anderson" <Zuldarin_noSpam_@Hotmail.com> wrote in message news:evCmjvBWCHA.1496@tkmsftngp11...
Hello, I have a sql2k table that has valid data in it. I have linked to it with Access XP but when I open the table to view I get #Deleted in all of the fields. I have done a search in TechNet and found an article that says I am running an older version of Jet and it instructs me to install the latest version (6) of jet. After doing this I am still getting the deleted records. I have tried installing Access and the update to Jet on a Win2K server and get the same error there. Anybody have any ideas before I spend $200 to call MS?
Thanks
Darin
|