Master and replica dbs in Access 2007

[olseni]

Hi all
I have an Access 2007 database (file format accdb) and I wish to make it a master database, and replicate the database, its design as well as the data to another location, and then syncronize the data daily during nighttime.

As far as I can see that should be posible, and I have tried using the standard Access help functions, finding a jro function that should enable the database to become a master, and also a jro function that should then create the replica.

However it doesnt seem to work. I have copied the code into VBA, but something is not going right, Access complains about the file format and things like that. Also I tried activating the VBA reference Microsoft Jet and Replication Objects 2.6 which seemed to solve some of my problems, but still I am not getting my master database 'replicable', which seem to be the first step.

Any ideas or help you can provide will be much appreciated ? and please note that I am not a VBA programmer, so it might be something really simple....
Thanks
Best regards
Ingrid

[nico5038]

Dear Ingrid,

I would start with reconsidering the use of replication. Checkout:
Microsoft Access 2000, Microsoft Access 2002, and Microsoft Office Access 2003 Replication FAQ is available in Microsoft Download Center
I've seen too much trouble with this feature.
It's in general not that much work to transfer just the added data and it will give much more control, as solving data mismatches will also require programming...

Nic;o)

[olseni]

ok, thanks. Was fearing that I would have to build it myself. Thanks anyway for you reply and suggestion.
Best regards
Ingrid

[missinglinq]

In point of fact, Replication cannot be used with ACCDB files! Micro$oft removed the function with the new file format. Allen Browne suggests using attached tables, connected to a database that supports replication, i.e.an MDB back end rather than an ACCDB back end, if you absolutely have to have it. But as Nic;o) has said, it is a process fraught with problems.

Linq ;0)>