Linked Table Manager

[mr3316a via AccessMonster.com]

I am using the following code to launch the Linked Table Manager in Access
2007:

DoCmd.RunCommand acCmdLinkedTableManager

My question is:
Is there a simple way to tell if the linking was Successful, Failed, or if
the user Canceled the process?

Thanks in advance
Mark

 

[Daniel Pineault]

Your code simply open the Linked Table Manager console. It will return
messages based on the process. It will tell you if it was successful or not.

The only other option would be to create your own table linking form/routine.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Armen Stein]

I am using the following code to launch the Linked Table Manager in Access
2007:

DoCmd.RunCommand acCmdLinkedTableManager

My question is:
Is there a simple way to tell if the linking was Successful, Failed, or if
the user Canceled the process?

Thanks in advance
Mark

If you want a more automated approach to relinking tables, you're
welcome to use our free J Street Access Relinker on our J Street
Downloads page: http://ow.ly/M56Q

It handles multiple Access back-end databases, ignores ODBC linked
tables, and can automatically and silently relink to back-end
databases in the same folder as the application (handy for work
databases or single-user scenarios). There's a ReadMe table with
instructions.

Per your question, it can also return a flag indicating whether the
relinking was successful.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[mr3316a via AccessMonster.com]

Thanks for the quick reply, and I am going to checkout your relinker.
However, I need to put something in place quickly.
What would the code look like to set the return flag?

I am using the following code to launch the Linked Table Manager in Access
2007:

[quoted text clipped - 7 lines]

Thanks in advance
Mark

If you want a more automated approach to relinking tables, you're
welcome to use our free J Street Access Relinker on our J Street
Downloads page: http://ow.ly/M56Q

It handles multiple Access back-end databases, ignores ODBC linked
tables, and can automatically and silently relink to back-end
databases in the same folder as the application (handy for work
databases or single-user scenarios). There's a ReadMe table with
instructions.

Per your question, it can also return a flag indicating whether the
relinking was successful.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[mr3316a via AccessMonster.com]

Yes, it returns the message to the user. However from an automation
standpoint, I have code running that its execution depend on what the user
did or didnot do.

Your code simply open the Linked Table Manager console. It will return
messages based on the process. It will tell you if it was successful or not.

The only other option would be to create your own table linking form/routine.

I am using the following code to launch the Linked Table Manager in Access
2007:

[quoted text clipped - 7 lines]

Thanks in advance
Mark

 

[Armen Stein]

Thanks for the quick reply, and I am going to checkout your relinker.
However, I need to put something in place quickly.
What would the code look like to set the return flag?

In our relinker, the flag is already set. It's very quick to
implement.

You don't have access to any return flag using the built-in Linked
Table Manager, that I know of.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com