469,613 Members | 1,204 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,613 developers. It's quick & easy.

Linked Tables Access

Is there a way to hard code what a path to a linked table would be
without
going through the Linked Table Manager or a re-linking process?

My issue is that I'm installing a database with linked tables onto
several
different networks. I can pre-determine what each path will be, but I
can't
do the re-linking or the Linked Table Manager remotely for each
network.

The files DbApp file and the DbData file both need to be installed on
each network because there will be multiple users in multiple
locations within a building.

Any work-arounds?
Nov 13 '05 #1
2 2324
Use the Connect property of the TableDef, and remember to RefeshLinks.

There is an example in solutions.mdb of how to check the lines on startup,
and - if the data is not found - pop up the Windows FileOpen dialog so the
user can locate it. Download from:

http://msdn.microsoft.com/library/de...dbdownload.asp

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Sam DeRT" <sa*****@hotmail.com> wrote in message
news:f3**************************@posting.google.c om...
Is there a way to hard code what a path to a linked table would be
without
going through the Linked Table Manager or a re-linking process?

My issue is that I'm installing a database with linked tables onto
several
different networks. I can pre-determine what each path will be, but I
can't
do the re-linking or the Linked Table Manager remotely for each
network.

The files DbApp file and the DbData file both need to be installed on
each network because there will be multiple users in multiple
locations within a building.

Any work-arounds?

Nov 13 '05 #2
I guess you could write the UNC path to each attached table into a
table in Access, open a recordset on that table and walk it,
reattaching each table.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Internet Arrow Limited | last post: by
2 posts views Thread by Robert McGregor | last post: by
4 posts views Thread by Neil Ginsberg | last post: by
3 posts views Thread by Zlatko Matić | last post: by
10 posts views Thread by Jim Devenish | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.