Hello,

I use sharepoint lists as a backend for my 2010 access database. I take the database off-line and perform sync when needed. I use 2007 format for syncing because i had some issues with 2010 automatic offline mode. The problem is as following example: table employees has foreign key to table departments (autonumber). I add a new department and a new employee to reference that department (primary and foreign key is decrementing negative number). Then I do sync. Sometimes table departments gets updated and primary keys get updated accordingly (becoming positive numbers) and the foreign key referenced in employees does NOT get updated. So the sync gives me an error saying that employees table has a non existing reference (employees still have negative number and new department has updated number). Most of the times sync goes through successfully. Any ideas why that happens and how to avoid it. Thanks!!!