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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Custom Data Types Not Visible In Access Linked Tables 1
Conneting to SQL server, Need advice 3
Linked tables to SQL 1
autonumber fields in SQL Express 2005 4
Can't link to MS SQL Svr 2005 table (#deleted) 8
What does linking a Access table to an SQL table mean? 2
ODBC Link to SQL 2005 4
any problem with 2003 mdb using sql 2005 tables linked ot another mdb? 2

Back
Top