UNsplitting a database

[Valerie]

I've managed to make yet another mess. After building my
database like I wanted it, I used the splitter utility to
store my tables on a shared computer. (We're a very small
company, and this computer serves as our wannabe server.)
Everything worked fine for a little while, but then the
computer began giving us problems across the board. It's
time to retire that computer, so I needed to move the
backend database to another location. The only problem is,
when I try to open the database, it still looks to the old
drive for the tables. What do I need to do to give it the
forwarding address?

 

[Rick B]

You have to delete each linked table in the front-end and then add them
back. To add them back, click the 'new' button, then click 'Link Table',
then find your back-end database and the tables that you wish to link to.

HTH

Rick B


I've managed to make yet another mess. After building my
database like I wanted it, I used the splitter utility to
store my tables on a shared computer. (We're a very small
company, and this computer serves as our wannabe server.)
Everything worked fine for a little while, but then the
computer began giving us problems across the board. It's
time to retire that computer, so I needed to move the
backend database to another location. The only problem is,
when I try to open the database, it still looks to the old
drive for the tables. What do I need to do to give it the
forwarding address?

 

[John Spencer (MVP)]

You can relink to the new location.

Open your database in design view and under the tools menu look for "Linked
Table Manager". In Access 97, it is an addin, so you may have to install it
from the installation disks.

Another option is to get the code from The MVP Access Site

http://www.mvps.org/access/tables/tbl0009.htm

The code looks complicated, but you basically need to copy and paste it into a
module and then call it.