Creating a blank new database from old

[gglazer]

Hi, all.

I have a database with multiple tables, scripts, etc. I would like to make
a copy of the whole database and then create a new database from only the
"shell" of the old one - all schema, code, etc. but with none of the actual
data. I could do this with copying the mdb file and a series of delete SQL
commands, but I don't want to have to remember all of the key dependencies.

Is there a feature in Access that will do this in fewer steps?

Much obliged,

Glenn

 

[Graham Mandeno]

Hi Glenn

Create your new database and go File > Get external data > Import. Select
your old database, then visit each tab of the Import Objects dialog and
click "Select All". Then expand the "Options>>" button and choose
"Definition only" under "Import Tables" before clicking OK.

 

[gglazer]

WOW. Awesome job, Graham. Fast response and EXACTLY what I was looking for!

Great job!

Best,

Glenn

Hi Glenn

Create your new database and go File > Get external data > Import. Select
your old database, then visit each tab of the Import Objects dialog and
click "Select All". Then expand the "Options>>" button and choose
"Definition only" under "Import Tables" before clicking OK.
--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hi, all.

I have a database with multiple tables, scripts, etc. I would like to
make
a copy of the whole database and then create a new database from only the
"shell" of the old one - all schema, code, etc. but with none of the
actual
data. I could do this with copying the mdb file and a series of delete
SQL
commands, but I don't want to have to remember all of the key
dependencies.

Is there a feature in Access that will do this in fewer steps?

Much obliged,

Glenn