🚀 go-pugleaf

You should use ADOX - import its type library or use Variant object. This
code is in JScript but you should have no problems to convert it in BCB.

Linked tables may not be visible in designer but you can set TableName
property at runtime.

//-------------------------------------------

var connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db_test.mdb";

var cat = new ActiveXObject("ADOX.Catalog");
cat.Create(connStr);

var tbl = new ActiveXObject("ADOX.Table");
tbl.ParentCatalog = cat;
tbl.Name = "DstTable";
tbl.Properties.Item("Jet OLEDB:Create Link").Value = true;
tbl.Properties.Item("Jet OLEDB:Link Datasource").Value =
"C:\\Temp\\SrcDB.mdb";
tbl.Properties.Item("Jet OLEDB:Remote Table Name").Value = "SrcTable";

cat.Tables.Append(tbl);

cat = null;

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi + ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Robert Emmons" <remmons@aurigen.com> ???????/???????? ? ???????? ?????????:
news:dklbtv08t10eh699aqct3ihjm6r2l58qd1@4ax.com...
> 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?
>