Linking...Access2002/SQL 2005...#deleted

  • Thread starter Thread starter elf
  • Start date Start date
E

elf

Data was originally imported from A2002 to SQL 2005 (dev ed). If I link the
table into Access, the datasheet is filled with #deleted. If I import it,
all the data comes in correctly. I've tried renaming the table, linking to
a different Access db, compacting the Access db...no go.

Any ideas?

(Sorry if this post is repeated, I'm having trouble with my e-mail client.
I've posted 3 times, but have so far not seen it show up after 2 days).

TIA
 
I finally figured this out. FYI, some of our original Access tables did not
have unique keys. What we usually do to convert to SQL in that case is add
an Identity field and define it as the unique key required by SQL. To be
safe, in larger tables with a lot of activity, I defined this field as
BigInt. Changing it to Int solved the problem. I'll just archive and
re-sequence if it ever becomes necessary.

Thanks for thinking about it.
 
Back
Top