Welcome to SPN

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

Sign Up Now!

Make adds to existing db and get current data from client

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

  1. SRussell

    SRussell
    Expand Collapse
    Guest

    I am helping a friend with their db. I added a table, added a form and
    changed some existing ones.

    How do I put the current data into the modified mdb I have?

    TIA
     
  2. Loading...

    Similar Threads Forum Date
    Nature Carbon Calculator Adds up to 1st Prize Breaking News Nov 25, 2010
    Sikh News Centurion Bank of Punjab Adds SuperDerivatives Multi-Asset Risk Management and Intere Breaking News Apr 2, 2008
    Islam UZBEK GOVERNMENT ADDS "SO-CALLED DEMOCRATS" TO ITS ENEMIES LIST (EurasiaNet.org) Interfaith Dialogues Jun 18, 2005
    President of Akamai Adds CEO Role (AP) Interfaith Dialogues Apr 5, 2005
    Toshiba adds partners for networking line (InfoWorld) Interfaith Dialogues Mar 25, 2005

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Wed, 10 May 2006 21:15:07 -0500, "SRussell" <srussell@lotmate.com>
    wrote:

    >I am helping a friend with their db. I added a table, added a form and
    >changed some existing ones.
    >
    >How do I put the current data into the modified mdb I have?
    >
    >TIA
    >


    With considerable difficulty, often.

    That's why it's almost always best to use the Database Splitter Wizard
    to split the database into a backend (containing only the tables) and
    frontend (with everything else). You can work on the forms, reports,
    and code using your own "testing" backend; when they're working right,
    the friend can simply replace their frontend with the new one, and
    relink it to their backend.

    You'll need to use File... Get External Data... Import to import a new
    table into the backend, but hopefully that will be much rarer than
    changing forms.

    John W. Vinson[MVP]
     
  4. SRussell

    SRussell
    Expand Collapse
    Guest

    "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    news:2ud5629glf687ep8imhvb202o3rhvhmlug@4ax.com...
    > On Wed, 10 May 2006 21:15:07 -0500, "SRussell" <srussell@lotmate.com>
    > wrote:
    >
    >>I am helping a friend with their db. I added a table, added a form and
    >>changed some existing ones.
    >>
    >>How do I put the current data into the modified mdb I have?
    >>
    >>TIA
    >>

    >
    > With considerable difficulty, often.
    >
    > That's why it's almost always best to use the Database Splitter Wizard
    > to split the database into a backend (containing only the tables) and
    > frontend (with everything else). You can work on the forms, reports,
    > and code using your own "testing" backend; when they're working right,
    > the friend can simply replace their frontend with the new one, and
    > relink it to their backend.
    >
    > You'll need to use File... Get External Data... Import to import a new
    > table into the backend, but hopefully that will be much rarer than
    > changing forms.


    Wow that sounds sucky :(

    Anyway to truncate a table in my db? I can hook in from SQL2005.
     
  5. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Thu, 11 May 2006 21:15:25 -0500, "SRussell" <srussell@lotmate.com>
    wrote:

    >Anyway to truncate a table in my db?


    Sure, just run a Delete query with no criteria:

    DELETE * FROM tablename;

    John W. Vinson[MVP]
     
  6. SRussell

    SRussell
    Expand Collapse
    Guest

    "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    news:sn2862p3c39fc89vl5cftreqp1msca8p74@4ax.com...
    > On Thu, 11 May 2006 21:15:25 -0500, "SRussell" <srussell@lotmate.com>
    > wrote:
    >
    >>Anyway to truncate a table in my db?

    >
    > Sure, just run a Delete query with no criteria:
    >
    > DELETE * FROM tablename;


    I knew it would be simple, thanks.

    __Stephen
     

Share This Page