I am not experienced with this but do your tables all have primary keys? Do any of the primary key fields allow nulls? Do you have timestamp type field?
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]