It's possible that the table in the other database is corrupted. Maybe do a
compact and repair on it.
Or you could link to that table then use queries to find the problem record.
After that you could run an append query and exclude the "deleted" record.

Signature
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> Hi,
>
[quoted text clipped - 4 lines]
> Thank you
> Chi
Chi - 26 Dec 2007 18:55 GMT
Hi Jerry,
Thank you soooo much! It works perfectly!
> It's possible that the table in the other database is corrupted. Maybe do a
> compact and repair on it.
[quoted text clipped - 10 lines]
> > Thank you
> > Chi