How do I save a db structure with no data

[frostman]

I have db that we need to share with some other co-workers, but only want to send them the structure, ie fully functional db so they can add there own data. How do I remove all data and retain the structure

 

[hjgoldstein]

What you need to do is create a new blank database and then import the tables, forms, queries etc from your existing database.

In your new blank database, click on File > Get External Data > Import.

You will be prompted to choose the database file you want to import. Select your live database and then you will see a list of all the tables in your database. Click "Select All" and then "Options" and you will see in the middle of the dialogue at the bottom "Import Tables". Select the radio button for "Definition only" and you can import the tables with no data.

Import all of the other bits and you have a fully functional database with no data.

Hope this helps.

 

[frostman]

Very helpful, only one problem, I have a switchboard form that accesses everything, an it copies blank, any ideas???

 

[hjgoldstein]

Sorry Frostman, I've never used Access' switchboards so I can't advise on them.

If you don't have too many functions on your switchboard, how about setting up a form with command buttons to use as your very own switchboard. A little macro or a couple of lines of code for each one should do the trick.

If anyone else has the gen on switchboards, great.

 

[glrpfi]

Ok the switchboards...

You need to be selective on which tables you bring over blank.

I segregate them by naming convention which makes it easier to spin off copies quickly, but thats a trivial point.

Key master tables like switchitems, etc., are brough over first, with data, and then the rest are brought over without.

happy friday