Question

Locked

Error message when syncing Microsoft Access databases

By CareersforWomen ·
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!

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Microsoft Access Databases are notorious for getting corrupted

by robo_dev In reply to Error message when syncin ...

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

Back to Hardware Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums