Recent content by step

I have actually found the problem. Thanks to those that had a look. I do not know how it happend but the primary key was not autonumber. That was the problem. When I tried to add a record, Access did not auto-generate the primary key value. Cheers, Step

Hi, I am pretty new to Access so please excuse me if my error is total muppetry. When running an INSERT INTO query in Access 2007 VBA I keep getting the error "Microsoft Access can't append all the records... due to key violations. I have read a few threads and cannot find the problem. Here...