How could i get the value by the system function linked table

[yanggy]

I've made a function with an phase to call the system function linked table manager.

DoCmd.RunCommand (acCmdLinkedTableManager)

And i want to retrieve the value after the operation by linked table manager. Could anyone tell me how?

 

[Golom]

Retrieve the value of what?

[blue]DoCmd.RunCommand (acCmdLinkedTableManager)[/blue]

Just runs the Linked Table Manager where you can reset the links. What "value" are you expecting to get?

 

[yanggy]

I want to retrieve the path of the linking database for example.

I want to see also the script of the form Linked Table Manager to know how it works. Is it possible?

Thanks

 

[PHV]

Have a look here:

http://www.mvps.org/access/tables/tbl0009.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[yanggy]

Thinks anyway.

But not exactly i want. I want to see how dose it work the intern function of Access.
Can we see the code of this form "acCmdLinkedTableManager" somewhere?

 

[CautionMP]

yanggy,
In a word, no.

And i want to retrieve the value after the operation by linked table manager. Could anyone tell me how?

This will let you check the new path of the linked table with a simple query.
[tt]SELECT Name, Database FROM MSysObjects WHERE Type=6;[/tt]

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[yanggy]

Thanks so much!!!!