423,319 Members | 2,562 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,319 IT Pros & Developers. It's quick & easy.

Error '3426' When Updating Database

P: n/a
Here's the code:
Private db As Database, rs As Recordset

Set rs = db.OpenRecordset("Table")

rs.AddNew
'User puts in some stuff in form and hits okay
rs.Update

This stuff works perfectly for the FIRST record only. When I try to add a second one, it gives me the runtime error '3426': This action was cancelled by an associated object.
Any ideas on how to fix this?

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Wed, 29 Dec 2004 18:27:15 GMT, "Christina Grabe via
AccessMonster.com" <fo***@AccessMonster.com> wrote:
Here's the code:
Private db As Database, rs As Recordset

Set rs = db.OpenRecordset("Table")

rs.AddNew
'User puts in some stuff in form and hits okay
rs.Update

This stuff works perfectly for the FIRST record only. When I try to add a second one, it gives me the runtime error '3426': This action was cancelled by an associated object.
Any ideas on how to fix this?

--
Message posted via http://www.accessmonster.com


Hi
see "PRB This Action was Cancelled by an Associated Object.(3426)"
perhaps, at
http://support.microsoft.com/kb/q189851/

or serach Google for "This Action was Cancelled by an Associated
Object" with the quotes.
"http://support.microsoft.com/kb/q189851/

David


Nov 13 '05 #2

P: n/a
I did those things before posting this and they didn't help much. My recordset was not pointing to a null and Google didn't give me much to go on. HOWEVER, I did get my database working anyway...I just still don' t understand where the issue was in the database. Thanks, though.

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.