Linked Table Manager or Table Properties

[Cheow Wang]

Hi,

In my VBA, I would like to retreive the info for the
Table Properties's Description. This table is actually
a linked table. How should I retrieve the following
info in my program?

Table Properties' Description :

Text;DSN=VATImport Unicode Specification;
FMT=Delimited;HDR=NO;IMEX=2;CharacterSet=1200;
DATABASE=D:\SAP Support\Shanghai VAT Project;
TABLE=VATImport - Unicode#txt

Thanks for any help!

Rgds,
Cheow Wang.

 

[Douglas J. Steele]

Make sure you have a reference set to DAO, and you'll be able to access that
using:

CurrentDb().TableDefs("MyTable").Connect

(replace "MyTable" with the actual name of the table)