Linked Tables - Access, Networked, Runtime

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Simon - 23 Sep 2003 21:40 GMT

I have a runtime version to deploy on a network. No
computer on the network has a full version of Access (I'm
using XP).

I want to deploy a split database. How can I set the path
to the data tables as they will appear when the rear end
is on the server and the front end is on workstations. I
cannot do this once it is installed on workstations as the
front ends will only have runtime tools. So I must
assigned the path correctly whilst it is on my own machine
under development. My machine is not connected to the
network, and so cannot see the path.

Windows 98 on workstations.

Any help much appreciated.

Simon

Reply to this Message

Paul Overway - 23 Sep 2003 22:35 GMT

You need several routines. See

http://www.mvps.org/access/api/api0001.htm

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

In addition to these, you need a routine to check whether the table links
are valid. Basically, you need to check each link, determine whether it is
valid, and if not use the routines referenced above to locate the proper
file and relink the tables.

--
Paul Overway
Logico Solutions, LLC
www.logico-solutions.com

> I have a runtime version to deploy on a network. No
> computer on the network has a full version of Access (I'm
[quoted text clipped - 14 lines]
>
> Simon

Reply to this Message