INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

How to

How to split a DataBase and relink tables. by pavewayammo
Posted: 18 Jun 03

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
     #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.


Back to Microsoft: Access Forms FAQ Index
Back to Microsoft: Access Forms Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close