Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Link table in Access and get #DELETE# in field data

Status
Not open for further replies.
rcbatlinux

rcbatlinux

Technical User
Mar 30, 2001
80
US
Anyone ever setup a link table in Access to an ODBC source and get data in the table that states "#delete#"? I had this happen with one other table setup and by changing the keys I resolved the problem but this one table I have I can't seem to resolve. If I Import the table it works fine.

rcbatlinux
 
Sort by date Sort by votes
Is it possible that the DSN's setup declares a max field length that is less than the field length of the data you are trying to link to?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dcern
  • Locked
  • Question
Ingres ODBC Driver slow
Replies
0
Views
546
dcern
dcern
Vary88
  • Locked
  • Question
Both One-Many and Many-One relations in fact table
Replies
0
Views
522
Vary88
Vary88
acoronel
  • Locked
  • Question
Error message to use active directory authetication to access SQL database.
Replies
0
Views
504
acoronel
acoronel
chainedtodesk
  • Locked
  • Question
update AS400 table from MS Access db
Replies
0
Views
492
chainedtodesk
chainedtodesk
Malbordio
  • Locked
  • Question
ODBC in PHP to connect to ServiceNow
Replies
1
Views
580
k5tm
k5tm

Part and Inventory Search

Sponsor

Back
Top