Question Locked

Error message when syncing Microsoft Access databases

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When we try to sync the primary copy of our database with another copy of the database that has been moved onto a flash drive from another computer, we keep on getting an error message and the two database do NOT sync.

The error message we get is:

?Synchronization between replica ?E:\CK DB (won?t sync) 8.28.09\Copy of Careers Database.mdb? and replica ?C:\Documents and Settings\[where our primary database is located].mdb? failed.

The search key was not found in any record."

Anyone know why we keep getting this error message and how we might address it? Thank you!

2 replies

by robo_dev

As a first step, make sure you've got plenty of backups of everything.

If the source database is corrupt, the replication process will not work.

I would try compacting the database, after making a backup of it.

Is the database very large? Access databases get cranky, slow, and unreliable as they get over about a gig in size.

Other common errors include indexing a memo field with lots of records.

http://www.access-programmers.co.uk/forums/showthread.php?t=92702

This discussion is closed to new replies.