Results 1 to 2 of 2
Thread: Un-Splitting a Database (2K)
2001-10-07, 22:29 #1JailMedGuest
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.
2001-10-08, 02:57 #2
- Join Date
- Jun 2001
- Crystal Beach, FL, Florida, USA
- Thanked 34 Times in 34 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.)