Copy Database

[Roddy]

I am building a database which will contain approximately 60 tables, associated forms, reports etc. This is a project specific database & I hope to be able to copy the database for other similar projects, emtying most (possibly all) tables while keeping their structure intact. Can anyone point me in a direction please?

 

[Jack Cowley]

Create new, blank db then use File > Get External Data > Import to import the forms, queries, etc. that you want. In the Import dialog click the Options button and select Definition Only for the tables...

hth,
Jack

 

[Roddy]

Thanks Jack. That helps for now, but is there a way I can do this programatically from a command button on a form?

 

[Jack Cowley]

Search help for TransferDatabase Method... You will find your answer there.

Jack

 

[Roddy]

Thanks again Jack. That should work

 

[Jack Cowley]

You are welcome. Good luck...

Jack