link using VB

[lala]

Hi
how can i link a table using VB

not refresh the current link, but change it to a different file using VB

thank you

 

[pbaldy]

You can link a table using TransferDatabase.

 

[lala]

thank you!!!!!!!!!!!!

 

[marianne]

yup pbaldy is true. I would also like to add that if you are using your VB to use transferdatabase, i guess you might need to update or add references to your VB before you can use transferdatabase method of access inside vb.

 

[lala]

Thank you so much
I got it to work without the references
Also, I used transfertext, forgot to mention it was a text file

Again, thank you!!!!!!!!!!!!!!!!
This forum is the best place for access, as I said 1000 times before

 

[marianne]

good for you. maybe you want to mark this post as solved.

 

[lala]

good for you. maybe you want to mark this post as solved.

are you trying to be sarcastic?

 

[lala]

You can link a table using TransferDatabase.

how do i mark it as solved?
last time i was here i don't think i was asked to do that
is this something new?