Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

create a "template" database from existing (complex) database

Discussion in 'Information Technology' started by magpie, Jul 28, 2006.

  1. magpie

    magpie
    Expand Collapse
    Guest

    I have an Access database that is somewhat complex that i would like to
    duplicate without the records. One of the issues that I have is that I
    need to have the old database with the records as well as a new clean
    database on the same computer. I have tried already to create a new
    database and import all of the tables, forms and macros to the new
    database using "get external data" and selecting the option "definition
    only" for those tables that i want to delete the records. Some of the
    tables appear as drop down menus in the forms and the "data"
    essentially a option for a feild. This method was about 80% successful
    but some of the links and pointers seem not to know where to look for
    information as I go about entering new records. I will get a message
    that says "jet database engine can not find ..." The biggest problem
    is that the existing database is extremely user friendly with a great
    front end. It opens to a main menu that allows choices for "data
    entry", "view and edit" "view only" etc.. which is convienient when you
    want to just look and make sure that you don't accidentally change
    records. It also allows collaborators to access the database based on
    a number that corresoponds to various permission levels. I have no
    idea how to make this happen in the new database. I know nothing about
    database design or language and have gone as far as I can figure out on
    my own. I would appreciate any advice or suggestions. tia--
     
  2. Loading...


  3. SusanV

    SusanV
    Expand Collapse
    Guest

    Hi magpie,

    Have you checked your relationships in the new db?
    --
    hth,
    SusanV

    "magpie" <maggiemcmillin@yahoo.com> wrote in message
    news:1150302124.814050.251000@p79g2000cwp.googlegroups.com...
    >I have an Access database that is somewhat complex that i would like to
    > duplicate without the records. One of the issues that I have is that I
    > need to have the old database with the records as well as a new clean
    > database on the same computer. I have tried already to create a new
    > database and import all of the tables, forms and macros to the new
    > database using "get external data" and selecting the option "definition
    > only" for those tables that i want to delete the records. Some of the
    > tables appear as drop down menus in the forms and the "data"
    > essentially a option for a feild. This method was about 80% successful
    > but some of the links and pointers seem not to know where to look for
    > information as I go about entering new records. I will get a message
    > that says "jet database engine can not find ..." The biggest problem
    > is that the existing database is extremely user friendly with a great
    > front end. It opens to a main menu that allows choices for "data
    > entry", "view and edit" "view only" etc.. which is convienient when you
    > want to just look and make sure that you don't accidentally change
    > records. It also allows collaborators to access the database based on
    > a number that corresoponds to various permission levels. I have no
    > idea how to make this happen in the new database. I know nothing about
    > database design or language and have gone as far as I can figure out on
    > my own. I would appreciate any advice or suggestions. tia--
    >
     
  4. dbahooker@hotmail.com

    dbahooker@hotmail.com
    Expand Collapse
    Guest

    if you used Access Data Projects; it would be trivial to get a script
    of all objects in a database and to create a blank database.

    SQL Server 2005 Express Edition.


    SusanV wrote:
    > Hi magpie,
    >
    > Have you checked your relationships in the new db?
    > --
    > hth,
    > SusanV
    >
    > "magpie" <maggiemcmillin@yahoo.com> wrote in message
    > news:1150302124.814050.251000@p79g2000cwp.googlegroups.com...
    > >I have an Access database that is somewhat complex that i would like to
    > > duplicate without the records. One of the issues that I have is that I
    > > need to have the old database with the records as well as a new clean
    > > database on the same computer. I have tried already to create a new
    > > database and import all of the tables, forms and macros to the new
    > > database using "get external data" and selecting the option "definition
    > > only" for those tables that i want to delete the records. Some of the
    > > tables appear as drop down menus in the forms and the "data"
    > > essentially a option for a feild. This method was about 80% successful
    > > but some of the links and pointers seem not to know where to look for
    > > information as I go about entering new records. I will get a message
    > > that says "jet database engine can not find ..." The biggest problem
    > > is that the existing database is extremely user friendly with a great
    > > front end. It opens to a main menu that allows choices for "data
    > > entry", "view and edit" "view only" etc.. which is convienient when you
    > > want to just look and make sure that you don't accidentally change
    > > records. It also allows collaborators to access the database based on
    > > a number that corresoponds to various permission levels. I have no
    > > idea how to make this happen in the new database. I know nothing about
    > > database design or language and have gone as far as I can figure out on
    > > my own. I would appreciate any advice or suggestions. tia--
    > >
     

Share This Page