Porting a split database.....

[raydelex]

I have a split database (Access 2003).

Now I need to port the database to the end-users' computer for a
demonstration. When I try to start up the database on the other
computer, it tells me that it cannot find the back-end database.

How do I tell the the "front-end" database where to locate the
"bank-end" DB that contains the actual tables on a computer other than
the one on which it was developed?

Thanks

[Tom van Stiphout]

On 24 Feb 2005 18:43:45 -0800, "raydelex" <rm*******@operamail.com>
wrote:

Tools / Database utilities / Linked table manager.
You can also reattach programmatically. Check your help file for
Connect and RefreshLink.

-Tom.

I have a split database (Access 2003).

Now I need to port the database to the end-users' computer for a
demonstration. When I try to start up the database on the other
computer, it tells me that it cannot find the back-end database.

How do I tell the the "front-end" database where to locate the
"bank-end" DB that contains the actual tables on a computer other than
the one on which it was developed?

Thanks

[Br]

raydelex wrote:

I have a split database (Access 2003).

Now I need to port the database to the end-users' computer for a
demonstration. When I try to start up the database on the other
computer, it tells me that it cannot find the back-end database.

How do I tell the the "front-end" database where to locate the
"bank-end" DB that contains the actual tables on a computer other than
the one on which it was developed?

Thanks

Either:
- use the same path names exactly on both computers
- use the built-in link manager in Access to update the links
- delete the linked tables and relink them
- use code to check the links when the program starts and prompts the
user for the location of the data, then it relinks the tables

Br@dley