create link table at run time

I

iccsi

I would like to know is it possible to create link table at run time?
If yes, any information is great appreciated,
 
I

iccsi

iccsi said:
I would like to know is it possible to create link table at run time?
If yes, any information is great appreciated,
Click to expand...

Certainly, it is possible.  All you have to do is create the
TableDef object (if it doesn;t already exist) and set its
Connect property.

Depending on what you are linking to, the linking
information that's needed in the Connect property can get
kind of complicated.  To see what you need, first connect
manually as if you did not want to use code,  Then use the
Immediate Window to see what Access did:
        ?CurrentDb.TableDefs![name of table].Connect

There is a modest amount of information about these things
in VBA Help.
Click to expand...

Thanks millions,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

link system table 1
Access Dcount (multiple criteria) 3
link table to a link table 1
link table using UNC 2
import text file 2
VBA - retrieve data on last create named range from previous inserted named range 0
run time version 9
user design IDE 5

Top