Solved

Make a Database Design Master from VBA using JRO

Posted on 2011-02-21
4
618 Views
Last Modified: 2012-05-11
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
Comment
Question by:VTKegan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 34945968
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
 
LVL 10

Author Comment

by:VTKegan
ID: 34945975
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
 
LVL 10

Author Comment

by:VTKegan
ID: 34946024
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
 
LVL 85
ID: 34946109
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question