Creating a new data base from an old one.

[PaulS44]

I want to create a new data base from an existing one in Microsoft Access. I want to use all the fields but not the data. Can I do this? I also want to keep the form that I created. Can anyone give me suggestions? Thank You!

 

[GUIDO22]

Create the new database file and simply select File/GetExternalData/Import.
Select the source database (your old DB file) and when the dialog appears select all the objects you wish to import. For tables - you can specify to import the structure/relationships only and exclude the data.

I am using Access '97 so the import menu option may be located somewhere slightly different......