Welcome to SPN

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

Sign Up Now!

How do I make a copy of the structures of all tables

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

  1. Karen

    Karen
    Expand Collapse
    Guest

    Hi All,
    I need to do some further development on an Access Application that
    I've been working on for some time. The users are working with part of
    the App now. I need to write more functions into it. How do I make a
    copy of the structures of all of the tables in the back-end database so
    that I can put a copy on my laptop to do some development?

    I'm using Access 2000.

    Karen
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Akal Takht concerned on drug addiction, copying during exams Breaking News Nov 5, 2013
    SciTech New Quantum Dot Technique Combines Best of Optical and Electron Microscopy Breaking News Jun 17, 2013
    India Copy of 48th Rreport of 'LOKPAL BILL 2011' Presented in Parliament Breaking News Dec 10, 2011
    Bhagats Sheikh Farid Copyright? History of Sikhism Nov 14, 2011
    Christianity Public library find is only surviving copy of rebel hymn book Interfaith Dialogues Jan 8, 2011

  3. SusanV

    SusanV
    Expand Collapse
    Guest

    Create a new blank database, then fail menu>Get external data. Point to your
    live app and select the option to copy the stable structure but not the
    data.
    --
    hth,
    SusanV

    "Karen" <kskipper@lamotte.com> wrote in message
    news:1151434115.471238.65640@i40g2000cwc.googlegroups.com...
    > Hi All,
    > I need to do some further development on an Access Application that
    > I've been working on for some time. The users are working with part of
    > the App now. I need to write more functions into it. How do I make a
    > copy of the structures of all of the tables in the back-end database so
    > that I can put a copy on my laptop to do some development?
    >
    > I'm using Access 2000.
    >
    > Karen
    >
     
  4. Phillip Windell

    Phillip Windell
    Expand Collapse
    Guest

    Create a new blank database.
    Import the tables from the other database.
    In the Options of the import you can tell it to import only the table
    structure without the data.


    --
    Phillip Windell [MCP, MVP, CCNA]
    www.wandtv.com



    "Karen" <kskipper@lamotte.com> wrote in message
    news:1151434115.471238.65640@i40g2000cwc.googlegroups.com...
    > Hi All,
    > I need to do some further development on an Access Application that
    > I've been working on for some time. The users are working with part of
    > the App now. I need to write more functions into it. How do I make a
    > copy of the structures of all of the tables in the back-end database so
    > that I can put a copy on my laptop to do some development?
    >
    > I'm using Access 2000.
    >
    > Karen
    >
     
  5. SusanV

    SusanV
    Expand Collapse
    Guest

    Oops - *file* menu. Silly spell check

    <grin>

    "SusanV" <svanallen@nospam-mvps.org> wrote in message
    news:%23bH5ZthmGHA.3508@TK2MSFTNGP05.phx.gbl...
    > Create a new blank database, then fail menu>Get external data. Point to
    > your live app and select the option to copy the stable structure but not
    > the data.
    > --
    > hth,
    > SusanV
    >
    > "Karen" <kskipper@lamotte.com> wrote in message
    > news:1151434115.471238.65640@i40g2000cwc.googlegroups.com...
    >> Hi All,
    >> I need to do some further development on an Access Application that
    >> I've been working on for some time. The users are working with part of
    >> the App now. I need to write more functions into it. How do I make a
    >> copy of the structures of all of the tables in the back-end database so
    >> that I can put a copy on my laptop to do some development?
    >>
    >> I'm using Access 2000.
    >>
    >> Karen
    >>

    >
    >
     
  6. SusanV

    SusanV
    Expand Collapse
    Guest

    Na,na - Beat ya!

    Hey, how have you been? Lost your email again - Doh!!!
    --
    SusanV


    "Phillip Windell" <@.> wrote in message
    news:O$z4PuhmGHA.3600@TK2MSFTNGP02.phx.gbl...
    > Create a new blank database.
    > Import the tables from the other database.
    > In the Options of the import you can tell it to import only the table
    > structure without the data.
    >
    >
    > --
    > Phillip Windell [MCP, MVP, CCNA]
    > www.wandtv.com
    >
    >
    >
    > "Karen" <kskipper@lamotte.com> wrote in message
    > news:1151434115.471238.65640@i40g2000cwc.googlegroups.com...
    >> Hi All,
    >> I need to do some further development on an Access Application that
    >> I've been working on for some time. The users are working with part of
    >> the App now. I need to write more functions into it. How do I make a
    >> copy of the structures of all of the tables in the back-end database so
    >> that I can put a copy on my laptop to do some development?
    >>
    >> I'm using Access 2000.
    >>
    >> Karen
    >>

    >
    >
     
  7. fredg

    fredg
    Expand Collapse
    Guest

    On 27 Jun 2006 11:48:35 -0700, Karen wrote:

    > Hi All,
    > I need to do some further development on an Access Application that
    > I've been working on for some time. The users are working with part of
    > the App now. I need to write more functions into it. How do I make a
    > copy of the structures of all of the tables in the back-end database so
    > that I can put a copy on my laptop to do some development?
    >
    > I'm using Access 2000.
    >
    > Karen


    You want just the table structure without data?

    File + Get External Data + Import Data
    Select the database from dialog box.
    Select the tables you wish to import.
    Click on Options.
    Select Import Relationships
    Select Import Tables Definition only.
    Click OK

    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  8. Wolfgang Kais

    Wolfgang Kais
    Expand Collapse
    Guest

    Hello Karen.

    "Karen" wrote:
    > Hi All,
    > I need to do some further development on an Access Application
    > that I've been working on for some time. The users are working
    > with part of the App now. I need to write more functions into it.
    > How do I make a copy of the structures of all of the tables in the
    > back-end database so that I can put a copy on my laptop to do
    > some development?


    Is the backend also an Access database? If so, try the following:
    Create a blank new database, click "file, external data, import...".
    Select the backend database file and click "import". Click "Options"
    to make the options appear at the bottom of the windows. There,
    under "import tables", you can choose to only import the structure
    of the tables. Select all tables and click "ok".

    --
    Regards,
    Wolfgang
     
  9. Phillip Windell

    Phillip Windell
    Expand Collapse
    Guest

    I'll send it to you along with the phone numbers :)
    All girls get the phone numbers free with any email request.
    If they don't show up shortly, let me know.

    --
    Phillip Windell [MCP, MVP, CCNA]
    www.wandtv.com


    "SusanV" <svanallen@nospam-mvps.org> wrote in message
    news:ehJ46whmGHA.3980@TK2MSFTNGP02.phx.gbl...
    > Na,na - Beat ya!
    >
    > Hey, how have you been? Lost your email again - Doh!!!
    > --
    > SusanV
    >
    >
    > "Phillip Windell" <@.> wrote in message
    > news:O$z4PuhmGHA.3600@TK2MSFTNGP02.phx.gbl...
    > > Create a new blank database.
    > > Import the tables from the other database.
    > > In the Options of the import you can tell it to import only the table
    > > structure without the data.
    > >
    > >
    > > --
    > > Phillip Windell [MCP, MVP, CCNA]
    > > www.wandtv.com
    > >
    > >
    > >
    > > "Karen" <kskipper@lamotte.com> wrote in message
    > > news:1151434115.471238.65640@i40g2000cwc.googlegroups.com...
    > >> Hi All,
    > >> I need to do some further development on an Access Application that
    > >> I've been working on for some time. The users are working with part of
    > >> the App now. I need to write more functions into it. How do I make a
    > >> copy of the structures of all of the tables in the back-end database so
    > >> that I can put a copy on my laptop to do some development?
    > >>
    > >> I'm using Access 2000.
    > >>
    > >> Karen
    > >>

    > >
    > >

    >
    >
     
  10. SusanV

    SusanV
    Expand Collapse
    Guest

    Woohoo!

    ;-D

    "Phillip Windell" <@.> wrote in message
    news:OS9oikrmGHA.2452@TK2MSFTNGP04.phx.gbl...
    > I'll send it to you along with the phone numbers :)
    > All girls get the phone numbers free with any email request.
    > If they don't show up shortly, let me know.
    >
    > --
    > Phillip Windell [MCP, MVP, CCNA]
    > www.wandtv.com
    >
    >
    > "SusanV" <svanallen@nospam-mvps.org> wrote in message
    > news:ehJ46whmGHA.3980@TK2MSFTNGP02.phx.gbl...
    >> Na,na - Beat ya!
    >>
    >> Hey, how have you been? Lost your email again - Doh!!!
    >> --
    >> SusanV
    >>
    >>
    >> "Phillip Windell" <@.> wrote in message
    >> news:O$z4PuhmGHA.3600@TK2MSFTNGP02.phx.gbl...
    >> > Create a new blank database.
    >> > Import the tables from the other database.
    >> > In the Options of the import you can tell it to import only the table
    >> > structure without the data.
    >> >
    >> >
    >> > --
    >> > Phillip Windell [MCP, MVP, CCNA]
    >> > www.wandtv.com
    >> >
    >> >
    >> >
    >> > "Karen" <kskipper@lamotte.com> wrote in message
    >> > news:1151434115.471238.65640@i40g2000cwc.googlegroups.com...
    >> >> Hi All,
    >> >> I need to do some further development on an Access Application that
    >> >> I've been working on for some time. The users are working with part
    >> >> of
    >> >> the App now. I need to write more functions into it. How do I make a
    >> >> copy of the structures of all of the tables in the back-end database
    >> >> so
    >> >> that I can put a copy on my laptop to do some development?
    >> >>
    >> >> I'm using Access 2000.
    >> >>
    >> >> Karen
    >> >>
    >> >
    >> >

    >>
    >>

    >
    >
     

Share This Page