By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,078 Members | 2,164 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,078 IT Pros & Developers. It's quick & easy.

Porting a split database.....

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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


Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.