Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2005
    Posts
    43

    Unanswered: duplicate database structure

    greetings:

    i thought i have done this once, but a while ago. and now i can't recall, so i'm hoping to get some feedback here.

    isn't there a way to duplicate a database's structure without the records? i just want the structure itself. i've read that i can copy a table, close the database, open a new database, and paste the table. however, i want this for all the objects in the database, not just tables.

    any thoughts?
    Mos

  2. #2
    Join Date
    Jun 2005
    Posts
    43
    did some more work.

    i've opened a new database, then went to tables > new > import table, which then opens another window.

    i've selected all the objects, and w/in the options button, selected definitions only (not data). got all the objects, however, when i try to open one, i get a message stating it can't find a macro.

    when i look in the macros, only autoexec was there. i've redone w/importing that and still not getting anything. (fyi, this database was set up such that when the database opens, a form "menu" is the default opening. there's a lot of vba, but the form menu wasn't created using the switchboard capabilities.)

    any thoughts?
    Mos

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Just copy the whole database and delete the data from the copy.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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