Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Linkes tables

0 views
Skip to first unread message

Javier Pesoa

unread,
Aug 24, 2001, 5:43:57 PM8/24/01
to
How can I modify in vba the path of the linked tables. It is stored in the
mSysObjects system table.
The pourpose of this is to upgrade a prototype to production database in
seconds without change the link one by one.


thanks,

Javier.


John Dunn

unread,
Aug 24, 2001, 6:15:00 PM8/24/01
to
problems will ensue if you point another database to linked tables referred
to in another database.

javier

no puedo!

Always try and place the linked tables in the same folder as their parent.

The reason for the linking in the sysObj is to ensure the correct tables are
matched against its' parent front-end.

hasta luego


Javier Pesoa <jpe...@adinet.com.uy> wrote in message
news:#7DZwWOLBHA.1496@tkmsftngp04...

John Griffiths

unread,
Aug 25, 2001, 11:43:50 AM8/25/01
to

"Javier Pesoa" <jpe...@adinet.com.uy> wrote in message
news:#7DZwWOLBHA.1496@tkmsftngp04...

see RefreshLink in help

TTFN John


Tony Toews

unread,
Sep 1, 2001, 7:53:26 PM9/1/01
to
"Javier Pesoa" <jpe...@adinet.com.uy> wrote:

You could use a a drive letter to link to the tables. Then use the
SUBST and Net Use commands to alternatively access a local directory
or a network share.

Thus you can use a two line batch file to remove the SUBST and setup a
network share. Then you can easily access the live BE using queries,
form and reports and find and fix problems. Then you can use another
batch file to delete the network share and setup the SUBST again.

tsserver.bat
subst z: /D
net use z: \\Server\TrackingSystem
You may need to add '/USER:your network user name' to the net use
command if you aren't already logged on to the domain, already using a
shared folder or printer or otherwise not authenticated to the server.
You don't want to put your password in a batch file.

tslocal.bat
net use z: /delete
subst z: d:\TSLocal

Tony
----
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

0 new messages