Query not working when database copied to another pc

  • Thread starter Thread starter A M Sullivan
  • Start date Start date
A

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
 
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.
 
Back
Top