Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access DB Replication Mistake, Master deleted/removed.

Status
Not open for further replies.

Cordury2

Technical User
Jan 22, 2005
55
US
I had a db replicated with the Design Master on my C: drive and the replicate on the network.

Being the genius that I am, I managed to delete the Design Master.

I used the Tools- Replication - Recover Design Master and it recovered the replicated db as Design Master.

So now there is just one db but it still shows the Replication Icons by the tables, forms, and Queries.

Any idea how to remove?

According to Help:
'After you've converted a database into a Design Master, you can't convert it back to its former status as a regular database. However, if you no longer want to use replication and want to decrease the size of a replicated database, you can create a new, regular database that contains all of the objects and data in your replicated database without the additional system fields, tables, and properties associated with replication'
 
The easiest way I've found...
First, make back up of your current DB. Then create a new DB and import all the objects from your old DB (include import/export specifications if you use any - under Options). Check out the new DB and make sure it functions correctly. Then use it as the Design Master and create new replica(s).
 
I have think I may have at least made it so I can update/edit the forms/Tables/queries.


I went to Tools/Replications/Synchronize and selected the checkbox to make the current DB the Design Master. The only thing is that, the forms/tables/queries still have the little yellow icon that represent replica.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top