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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Key viloation on Duplicates OK- field

Status
Not open for further replies.
Reinier11

Reinier11

Technical User
Jun 19, 2003
22
ES
Hi all,

I'm trying to append rows to a table, but can't get it right.
After confirming to update, I get the message access cannot append due to key violations. How is this possible if there are no key fields in the table to append to? (I removed the keys to test this)

Any help would be appreciated,
Reinier
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

lameid
  • Locked
  • Question
Execution Slowing on iterative generation of PDF's
Replies
3
Views
601
lameid
lameid
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
728
renigar
renigar
atadbitslow
  • Locked
  • Question
comparing fields, one populated with data and one blank 2
Replies
8
Views
526
atadbitslow
atadbitslow
clevercat88
  • Locked
  • Question
Field in table will not filter - info update
Replies
0
Views
223
clevercat88
clevercat88
PizMac
  • Locked
  • Question
error 3027 database or object is read-only
Replies
5
Views
510
PizMac
PizMac

Part and Inventory Search

Sponsor

Back
Top