[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 631
  • Last Modified:

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?
0
VTKegan
Asked:
VTKegan
  • 2
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If I'm not mistaken you can use the MakeReplicable method of the JRO library:

http://msdn.microsoft.com/en-us/library/bb237209(v=office.12).aspx

According to that page, the example code "demonstrates how to create a Design Master with the MakeReplicable method."

0
 
VTKeganAuthor Commented:
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.
0
 
VTKeganAuthor Commented:
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.

0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now