Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Nov 2002
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Blank copy of database (2000)

    How do I make a blank copy of an existing database, including tables, forms and reports? I then want to add new records to this new database.
    Please help
    Thanks

  2. #2
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Blank copy of database (2000)

    With the destination (blank) database open, select File...Get External Data...Import... Point to the source .mdb file in the browser and open it. Access lets you pick the Tables, Queries, Forms, Reports, Pages, Macros, and Modules to import. It sounds like you may want to "Select All" on each tab (make sure you select each tab -- "Select All" selects all of the contents of the current tab only). To avoid importing the data contained in your tables, click on "Options >>" and under "Import Tables" select the "Definitions Only" option. Review the other options to make sure you're including everything you want (e.g., relationships, menus & toolbars). Click OK and voila!

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Blank copy of database (2000)

    In addition to Tom's excellent reply, if you have set startup options in the current database, you will have to recreate them (Tools | Startup...) in the new database. They are not copied automatically. The same holds for non-standard references in the Visual Basic Editor (this is only relevant to you if you have Visual Basic code in your database.)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •