asked on

Make a Database Design Master from VBA using JRO

I have a database system that is using replication from Access 2003.

I have a design master template that is stored on our corporate server, and if anyone using the Front End wants to create a new project, then they would using the UI in the front end, click create new, and it would copy the design master template to a directory that they choose. However it automatically makes that copy a Replica of the design master on the server. Is there a way that I can copy the database from the server to the location they specify, and then set that new copy to be a design master from VBA?

ASKER CERTIFIED SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

VTKegan

ASKER

I tried using that method, and it throws back an error saying the database is already replicable. But it is a replica and not the design master.

VTKegan

ASKER

Ok... so the problem is having the template file already as a design master. I have to use a file that has not yet been made replicable as the template, and then copy that blank file to the new location and then I can use the MakeReplicable method you suggested.

Thanks for the help.

Scott McDaniel (EE MVE )

Yes - you must "promote" a replica to DM, and if you create a database from a template of a DM, then JRO will make the assumption that it's already a DM.

At least that's what I recall from my foray into replication years ago.