Can't synch Access DBs

[ITSONLYME4]

We have two access Databases and synch them on a regular basis. One is a master DB that only one person accesses and the other is a DB that several people input data into.

This morning when trying to sync the two .. getting this error:

"synchronization failed. The field is too small to access the amount of data you attempted to add. Try inserting or pasting less data:

SOUNDS like data in the Second table violates some kind of constraint in thr Master Table.. ?????

Not really sure how to figure out which data is the culprit.. can anyone help??????

 

[johncallaghan]

I suggest you look at the data structure of each table in both DBs in particular the maximum length of string fields.

Cheers

John

 

[ITSONLYME4]

Thank you!