link a table through code

  • Thread starter Thread starter Rover
  • Start date Start date
R

Rover

I have a A2k db on a server. I can create a table (through a make table
query) on a separate db on another server. How do I use that table
(access it) thought code. By hand, I'd do a Tools / database Utilities
/ Linked table manager but don't know how to do that within my form.

Jim
 
I'll Answer my own question:

The make table:

SELECT [clmdet Table].Claim, [clmdet Table].WS INTO tbl_test_otherDB IN
'c:\testDB.mdb'
FROM [clmdet Table];

Reference to it:

SELECT tbl_test_otherDB.Claim
FROM tbl_test_otherDB IN 'c:\testDB.mdb';

So, very nicely, even though the table does not show in my original db,
I can access it using the second query.
 
Back
Top