Replicated database in Access 2007 and 2010

[Eltjo]

I run a few replicated Access databases. These are used all over the world. The choice for replication was made because the database should be able to run stand alone when outside the office, and changes needed to be shared with other users.

I am not a Pro. I started with Access 2003. After upgrading to Office 2007 we still could run the .mdb files. Synchronisation was OK.
Now, I am the first of my team who changed to Windows 7 and Office 2010. I noticed that the replication conflict utility was no longer a part of Access 2010 and I had to write my own.

Again synchronisation with the master was OK.
When an other user (still running Windows XP and Office 2007) tried to synchronize his copy, his copy became corrupted.

In VBA an error message pops up "Compile error: Can't find project or library". when triing to open a table:
rsPers.Open "SELECT Personal.* FROM Personal;", CurrentProject.Connection, adOpenStatic, adLockOptimistic
The error shows up on "adOpenStatic"
Can anyone tell me how to deal with this?

[NTC]

So if I understand your post - you have done some development in 2010....but there is a user in 07; potentially this is the root cause of the error. Development must always be done in the oldest version.

This means, as a developer, I keep 02(Office XP), 03, 07 and 2010. I decline any work with Access97 at this point. If you are the internal developer of your organization - you must find out all the vintages out there and do development in the olderst version. Alas but I do not think there is any choice in this.

Sorry not to be more helpful,

[boblarson]

It sounds like you are suffering from the SP1 issue regarding 2010 or Windows 7. If EITHER of those is on that machine and the frontend was originally compiled on a non Office 2010/Win7 SP1 machine, then the ADO registry keys will not be correct as Microsoft changed them in both of those. So, you would need to compile the frontend (by going to the VBA window and doing DEBUG > COMPILE <project name here>) on the SP1 machine so that it will work.

[Eltjo]

Thanks,

Due to company policy my computer had to be replaced. Curently Windows 7 is the standard operating systen. I have the choice for Office 2007 or 2010. Whne I go back to Office 2007, will that give me the same environement as Offcice 2007 and Windows XP, or do I have to go back to Windows XP as well?

Regards, Eltjo

[boblarson]

You don't have to go backwards at all, but EVERYONE should be on the same operating system and same version of Office. If they are not, those who are not on SP1 of either Windows 7 or Office 2010 SP1, need to compile their frontend separately from anyone who has the SP1 version. That is the situation.