Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to split a DataBase and relink tables.
How to
This is a pretty easy task once you do it one time. Now this may seem stupid but you can split a database that has link to another database table or Excel spreadsheet already but when you split the database those links stay in the Front End (there are no links to links).
SPLITTING THE DATABASE
When you first split the DB it will be asked you where to place the Back End. You can place this anywhere as long as you can find it later and if it is on a share drive that all users have read/write access to it. I recommend putting it in a sub directory in the same directory as the Database you are splitting and leave the name as is.
To split the database go to Tools/Database Utilities/Database Splitter. Now you can place the Back End where you want it to be permanently or to a temp location but if you put it in the temp location you will have to follow the Relink instructions below. Now keep in mind that the Front End can be placed any where and you can have several copies of it connected to the same Back End.
BACK END
___________|___________________
| | |
| | |
FRONT END FRONT END FRONT END
![[pc3]](/data/assets/smilies/pc3.gif "[pc3] [pc3]")
#1 #2 #3
To do this the Back End must stay in the same location. You can link one Front End to the Back End and then place copies of it on Client computers. Only problem with this is when you change the structure of the Front or Back End you will have to place a new copy of the Front End to the Client computer.
RELINKING
Now lets say you placed the Back End on a shared drive and the network admin has changed the drive letter for that drive. What is going to happen is the Front End will not be able to get any data from the Back End. You will have the forms but no tables. Do the following to relink the tables.
On the Front End of the Database go to Tools/Database Utilities/Linked Table Manger. In the new window press Select All and check the box at the bottom named "Always prompt for new location". Press the ok and it will ask for the new location of the Back End. That is it.
![[bomb]](/data/assets/smilies/bomb.gif "[bomb] [bomb]")
SPLITTING THE DATABASE
When you first split the DB it will be asked you where to place the Back End. You can place this anywhere as long as you can find it later and if it is on a share drive that all users have read/write access to it. I recommend putting it in a sub directory in the same directory as the Database you are splitting and leave the name as is.
To split the database go to Tools/Database Utilities/Database Splitter. Now you can place the Back End where you want it to be permanently or to a temp location but if you put it in the temp location you will have to follow the Relink instructions below. Now keep in mind that the Front End can be placed any where and you can have several copies of it connected to the same Back End.
BACK END
___________|___________________
| | |
| | |
FRONT END FRONT END FRONT END
#1 #2 #3To do this the Back End must stay in the same location. You can link one Front End to the Back End and then place copies of it on Client computers. Only problem with this is when you change the structure of the Front or Back End you will have to place a new copy of the Front End to the Client computer.
RELINKING
Now lets say you placed the Back End on a shared drive and the network admin has changed the drive letter for that drive. What is going to happen is the Front End will not be able to get any data from the Back End. You will have the forms but no tables. Do the following to relink the tables.
On the Front End of the Database go to Tools/Database Utilities/Linked Table Manger. In the new window press Select All and check the box at the bottom named "Always prompt for new location". Press the ok and it will ask for the new location of the Back End. That is it.