MS Access Linked Tables

Article View: borland.public.cppbuilder.database.ado

Article #1997

Back to borland.public.cppbuilder.database.ado Previous Next

#1997

From: Robert Emmons
Date: Tue, 09 Dec 2003 14:05

16 lines
1634 bytes

I'm using a TADOConnection component which connects to a Microsoft
Access Database which has a linked table.  I can use the linked table
in queries by designating it in TADOQuery.SQL, but the linked table
does not appear on as a choice on TADOTable.Name.

Can a linked table in an MS Access database be connected to a
TADOTable?

I have a short program in MS Access which re-links under certain
conditions if the database is moved to a different folder.  It uses
the following MS Access property and method

    myTable.Connect = ";DATABASE=" & dataPath
    myTable.RefreshLink()

Are similar properties available in TADO components?

Technical Details

Message-ID: <dklbtv08t10eh699aqct3ihjm6r2l58qd1@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!news-out.visi.com!petbe.visi.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsgate.cistron.nl!skynet.be!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,3d60f5d5e721138,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-12-09 06:09:43 PST
From: Robert Emmons <remmons@aurigen.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: MS Access Linked Tables
Date: Tue, 09 Dec 2003 09:05:29 -0500
Message-ID: <dklbtv08t10eh699aqct3ihjm6r2l58qd1@4ax.com>
X-Newsreader: Forte Agent 1.93/32.576 English (American)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 68.193.14.50
X-Trace: newsgroups.borland.com 1070978668 68.193.14.50 (9 Dec 2003 06:04:28 -0700)
Lines: 17
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!news-out.visi.com!petbe.visi.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsgate.cistron.nl!skynet.be!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail