Query not working when database copied to another pc

[A M Sullivan]

I developed a database on my pc using Access 2002, for
use by my sister on her pc using Access 2000. When I make
changes, I copy the mdb file from my pc to hers. Until
now, all has been working well. I have recently created a
new append query which works correctly on my pc.
When I copy it to the other pc, the query won't work
correctly - creating up to 5 copies of the same record.
Any help would be greatly appreciated.

Thanks

Annette

 

[Fredg]

Does the query call for more than one table?
Check the table relationships in her query.
If you have multiple tables without a relationship, you will get a Cartesian
effect.