Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    20
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Access 2000 (2000)

    I have two identical databases. One is on my hard drive and the other is on a floppy drive. The records on the floppy drive are new and need to be added to the database on my hard drive. How do I combine the one on the floppy disk into the one on the hard drive so that the database on the hard drive will not be renamed or linked to the other database.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2000 (2000)

    First of all, copy the database on the floppy onto your hard disk. Never use a file directly on a floppy. This is asking for problems.
    Once that is done, open your database on the hard drive (the original one) and use File / Get External Data / Link Tables to link the tables from the database that come from the floppy. If the tables have the same names the link name will be the same with a 1 added at the end of it.
    Use now one or more append quer(y)(ies) to add the records from the floppy-database to the other.
    Francois

Posting Permissions

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