Append Query

[kevmc]

I have two databases wich include 3 tables each,Employees, Courses Attended and Courses, one for current employees and their training records and the other is for employees that have left, which also shows the courses they did.

When an employee leaves I would like to append that record from one database to another along with it's relevent records. I've tried but as yet have not got it to work. I get messages saying '0 records will be appended' amongst others, key violations, lock violations and validation rule violations.

I haven't been using Access that long, so only have a basic knowledge. Any help would be gratefully received.

Thanks.

 

[FoFa]

Key violation usually means you are either duplicating a unique key, or you maybe trying to insert the wrong data type (string in a number kind of thing as an example). Validation Rule Violation means there is a validation rule in the table (on one or more columns), and you are not following it/them. Locking would mean you have a record locked you are trying to access, there are many ways this happens in Access depending on options set and what you have open. This is not all that hard, but you must make sure the data you are appending conforms to the tables you inserting the data in. Once you have that cleared up, it should be easier. I would start with that and post back any specific problems you are having.

 

[kevmc]

As I am limited in my knowledge of Access, could you tell me how to combat these problems.

Can you only append from one table to another, one at a time or should all corresponding records be appended to all tables

Thanks for your help

kevmc

 

[FoFa]

You should append to each table individually