08-02-2001, 02:19 PM
I accidently made a design master of my database.
Is there way to change a design master into an clean database. By throwing out all system tables and stuff. Or would i mess up the whole design.
Every copy i make is a replica and can't be redesigned. My latest clean backup goes miles back.
08-02-2001, 04:20 PM
I found this in MSDN. I hope it helps you.
Making a Replicated Database a Regular Database
After youíve converted a database to a Design Master, you canít convert it back to a regular database. However, if you no longer want to use replication, 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.
To make a replicated database a regular database
Create and open a new, blank database in Microsoft Access.
On the File menu, point to Get External Data, and then click Import.
In the Import dialog box, click the replica that contains the objects that you want in the new, regular database, and then click Import.
In the Import Objects dialog box, click the objects (except tables) that you want to import into the new database, and then click OK.
In the new database, create a query for each table in the replica that takes all the data in the replica and puts it into tables in the new database.
For each table in the new database, create the same indexes and relationships that existed in the replica table.
Save your new database.
I think therefore I am... sometimes right. images/icons/wink.gif
08-03-2001, 09:42 AM
Thank you . I found this site where you can download a file to unreplicate a db . It is a bit tricky cause it erased all my queries. but if you keep them in your design master you can get them from there
thanks any how