Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Camp Lejeune, North Carolina, USA
    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
    Sint Niklaas, Belgium
    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.

Posting Permissions

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