Results 1 to 2 of 2
  1. #1

    Un-Splitting a Database (2K)

    I have a database, created in 97 but updated to 2k. The database requires the data files to be in a specific location. I need to change that location. How do I do it?

    The database was split and I don't know how to recombine it or tell it where the needs to be moved to. The file will be used over a network.

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 40 Times in 39 Posts

    Re: Un-Splitting a Database (2K)

    You don't need to un-split the database. When the tables were created in the frontend, they were linked to tables in a database in a specific location. You just need to go to the Linked Table Manager (in A2000, from menubar select: Tools | Database Utilities | Linked Table Manager). You can click the button to select all the tables, then make sure the checkbox is marked that says "Ask for new locations?". Then Ok it. A standard Windows file select box will popup. Navigate to the new location of the backend. Hint: If backend is on a server, don't use mapped drives on workstations. Find the server in network neighborhood; which uses the UNC to find server (example: //server/c/...etc.)
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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