How do I "tell" the Front-End of a DB where the Back-End is?

[Mike Webb]

Using Access 2K2; skill level: Novice.

I have a very small database of contacts that wish to deploy to the 6 people
in our office. After searching the Help menu and newsgroup via Google, I
decided to split the database.

Used the wizard and worked like a charm. Now .... when I send the front-end
to the other employees, how will it know where to find the back end???

TIA,
Mike Webb
Platte River Whooping Crane Maintenance Trust, Inc.\
a non-profit 501(c)(3) organization

 

[SnapBox]

It supposed that the front-end works when you link the tables... so you only need to do the following

1. Go to File men
2. Select Get External Dat
3. Click on Link Table
4. Look the path for your back-end and link the tables that you need

Hope helps

Snap

 

[Douglas J. Steele]

Assuming the back-end is on a server, use a UNC
(\\server\share\folder\file.mdb) to link to the back-end rather than a
mapped drive letter (F:\folder\file.mdb) and you won't have to worry about
it.

Under Tools | Database Utilities on the menu bar, you'll find the Linked
Table Manager. Select all of the tables and click on the "Always prompt for
new location" check box. To set a UNC through the Linked Table Manager, go
through "My Network Places" rather than finding the back-end using the drive
letter.

Alternatively, you could have have your users use the Linked Table Manager
to relink it themselves.

 

[Mike Webb]

Assuming the back-end is on a server, use a UNC
(\\server\share\folder\file.mdb) to link to the back-end rather than a
mapped drive letter (F:\folder\file.mdb) and you won't have to worry about
it.

Under Tools | Database Utilities on the menu bar, you'll find the Linked
Table Manager. Select all of the tables and click on the "Always prompt for
new location" check box. To set a UNC through the Linked Table Manager, go
through "My Network Places" rather than finding the back-end using the drive
letter.

Alternatively, you could have have your users use the Linked Table Manager
to relink it themselves.