Welcome to SPN

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

Sign Up Now!

Access database

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

  1. Glen

    Glen
    Expand Collapse
    Guest

    I have a new database created and want to import an older Access database
    into it. I have tried to import and export and neither works. I have
    checked the titles of fields and changed to reflect what is in the new
    database but it still doesn't work. Any suggestions.
     
  2. Loading...


  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Wed, 26 Jul 2006 10:19:02 -0700, Glen
    <Glen@discussions.microsoft.com> wrote:

    >I have a new database created and want to import an older Access database
    >into it. I have tried to import and export and neither works. I have
    >checked the titles of fields and changed to reflect what is in the new
    >database but it still doesn't work. Any suggestions.


    Please explain "doesn't work". Do you get an error message? In
    incorrect import? Import tables but no records in those tables? What
    are the two Access versions? What steps did you take to do the import?

    Give us a bit of help here...

    John W. Vinson[MVP]
     
  4. Glen

    Glen
    Expand Collapse
    Guest

    By not working I mean, I go to File and got to import and select the old
    database and it doesn't do anything. I does not bring the information from
    the old database into the new one. I go to the old database and got to File
    and select Export and I get nothing. I do not know version the new database
    was created in since I was not the person that created it and I have ask the
    person that created it and he doesn't know either. The old Access database
    was created several years ago, probable 3 or 4 years, and has been converted
    to different versions of Access since it was created.
    I have changed the names on the old database to reflect what is on the new
    one and still nothing. There is something I am missing but I cannot figure
    out what.
    Any suggestions would be very much appreciated.

    "John Vinson" wrote:

    > On Wed, 26 Jul 2006 10:19:02 -0700, Glen
    > <Glen@discussions.microsoft.com> wrote:
    >
    > >I have a new database created and want to import an older Access database
    > >into it. I have tried to import and export and neither works. I have
    > >checked the titles of fields and changed to reflect what is in the new
    > >database but it still doesn't work. Any suggestions.

    >
    > Please explain "doesn't work". Do you get an error message? In
    > incorrect import? Import tables but no records in those tables? What
    > are the two Access versions? What steps did you take to do the import?
    >
    > Give us a bit of help here...
    >
    > John W. Vinson[MVP]
    >
     
  5. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Thu, 27 Jul 2006 05:53:01 -0700, Glen
    <Glen@discussions.microsoft.com> wrote:

    >By not working I mean, I go to File and got to import and select the old
    >database and it doesn't do anything. I does not bring the information from
    >the old database into the new one. I go to the old database and got to File
    >and select Export and I get nothing. I do not know version the new database
    >was created in since I was not the person that created it and I have ask the
    >person that created it and he doesn't know either. The old Access database
    >was created several years ago, probable 3 or 4 years, and has been converted
    >to different versions of Access since it was created.
    >I have changed the names on the old database to reflect what is on the new
    >one and still nothing. There is something I am missing but I cannot figure
    >out what.
    >Any suggestions would be very much appreciated.


    It sounds like you're trying to import "the database". It doesn't work
    that way! A database is a CONTAINER for multiple objects. File...
    Import opens up a dialog which allows you to select *which* objects
    (tables, forms, queries, etc.) you want to import - it doesn't import
    anything until you do so.

    You can tell which version of Access you're using by selecting Help...
    About on the menu. It might help us if you would do so on both
    databases, the one you're importing from and importing to.

    John W. Vinson[MVP]
     

Share This Page