Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Location
    Australia
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Acess 2000 backup (2000)

    Hi, I am using windows XP and Acess 2000. I am wanting to back up the database I am using and then use it in Acess 2000 on another machine to experiment and design etc without affecting my original. Everytime I back up it won't open it because it can't find it as it keeps the address information etc (by the looks) as the original machine. Help please!!!

  2. #2
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Wellington, New Zealand
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Acess 2000 backup (2000)

    It sounds like you have some linked tables in your datababse?

    Can you confirm if this is the case (linked tables have a little black right arrow next to them in the DB Window)?

  3. #3
    New Lounger
    Join Date
    Jun 2002
    Location
    Australia
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Acess 2000 backup (2000)

    Thanks for that. Yes I have got linked tables.

  4. #4
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Wellington, New Zealand
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Acess 2000 backup (2000)

    That means that you will need to take a copy of any database(s) that the linked tables point to as well as the 'front end' database... then on the machine you will use for testing...use the Linked Table Manager to re-link the tables to the appropriate (copy) database again.

    If you didn't already know that is ...

  5. #5
    New Lounger
    Join Date
    Jun 2002
    Location
    Australia
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Acess 2000 backup (2000)

    Thanks. I didn't know that. Learning as I go.

  6. #6
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Wellington, New Zealand
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Acess 2000 backup (2000)

    No Problem

    You can find the Linked Table Manager under the TOOLS --> DATABASE UTILITIES menu option

    J

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Acess 2000 backup (2000)

    The database probably contains tables linked to another database on the original machine.

    If this is the case, and you want to use the database on another machine, you must copy the linked database too.

    Yo

Posting Permissions

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