Insert Linked table through code?

  • Thread starter Thread starter Sunny
  • Start date Start date
S

Sunny

Hi

Can I insert a linked table through code? I saw the mvps website, but
it only refreshes link on an existing table. How can i insert a new
one?

any help would be appreciated

thanks
Sunny
 
Sunny said:
Hi

Can I insert a linked table through code? I saw the mvps website, but
it only refreshes link on an existing table. How can i insert a new
one?

any help would be appreciated
Click to expand...

The simplest way is to use DoCmd.TransferDatabase with acLink for the
first argument. See the online help for details. Here's an example:

DoCmd.TransferDatabase _
acLink, _
"Microsoft Access", _
"C:\Temp\SomeOtherDB.mdb", _
acTable, _
"TableToLink", _
"NameForTableHere"
 

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

VBA - retrieve data on last create named range from previous inserted named range 0
Change one table link by vba 1
Refreshing linked table 2
How can I get the last row that was inserted in a table 4
insert a deleted record back in access table at the same location 2
Inserting between databases 2
Access 2007 - Copy linked table to a local table or have linked tableas read-only 0
Access Sequentially numbered column that resets with each new sample 0

Back
Top