Extract database after design and testing

[Sam]

After design and testing is done, what is the best way to extract a clean copy of the dB with all the objects and relations intact ?

[isladogs]

You can import all objects into a new database making sure you first tick the various options to ensure e.g. relationships are transferred.
However, normally I find it sufficient and usually faster to decompile, recompile then compact. I always make a backup first

[CJ_London]

you may want to remove all data in which case if importing to a new db, you have the option to not import the data (i.e. select Definition Only'). If you require some tables with data, import those separately

[Gicu]

Here is my free data cleaner if it helps:
http://forestbyte.com/ms-access-util...-data-cleaner/

Cheers,

[Sam]

Thank you all. Of course, I meant extracting without the test data.
Gicu, I'm getting an install error because the version is 32bit. But thanks anyways. I have been reading a lot through some of the suggested resources, including yours.

BTW, I am an old forum hand and a strong believer of forums v/s the new social media apps. Have been moderating and running some, but quite a different subject.

[Micron]

Opening a brand new db and importing all objects as suggested is the way to go. Make sure you click the options button because IIRC, the default is to import data in the tables. You also may want to bring over groups, specs, images, etc.