I have just completed development of a database and would like to save a 'clone'. What is the best way to do this?

Also as my database expands I envisage adding bulk data. Is creating a mini database of the data (with it's key) and using an update query better than 'importing'.

What do you mean by clone?



Sal

Importing should be fine...it works similar to an update and allows you to map across various field names...If your field names are synced up, it probably really doesnt matter which method you choose. Is the main table used primarily for archiving??

John

By clone I mean an empty database with (i.e. no records) auto numbers set to 0. Something that I can deliver (and a 'Gold standard' in case a replacement is required)

I have used the update route to add data to fields in bulk, but I agree that using import is good for initialisation. Thanks

I think I've found what I want it's in Get External Data / Import / {dbname} and then there are a raft of choices which cover my needs.