By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,461 Members | 2,184 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,461 IT Pros & Developers. It's quick & easy.

Access 2000 - Error 3426 "This action was cancelled by an associated object" - info

P: n/a
Something to add to your trivia bank.

I've seen previous questions on this error but they've all been for
adding new records to the RecordsetClone. I got it trying to edit an
existing record.

I have a "Roles" subform on a Job form where employees are assigned to
jobs with the roles being "lead architect", "landscape architect",
etc. The table being updated has EmployeeID, RoleID, StartDate,
EndDate, etc.

I'm using the AfterUpdate proc for StartDate to close off other
records for the same person by going through the RecordsetClone in a
loop. It's always worked for me before, but this time I get error 3426
on the .Edit line.

What's different about this table? The primary key is a combination of
the EmployeeID and RoleID fields. Ah ha! I've been in the habit of
creating an artificial Autonumber primary key field for intersection
tables, but this time for some reason I can't recall I decided to use
a concatenated primary key.

I created a RoleID Autonumber field and made it the primary key. Error
no longer occurs. Bingo!
--
Regards.
Richard.
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.

Browse more Microsoft Access / VBA Questions on Bytes