Is there a way to run link tables thru code?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Damon Heron - 20 Nov 2006 21:07 GMT

Is it possible to link tables at startup in code and test for links in the
same code? I have the menu item "Link Tables" on the menu right now, but
the user may link the tables over and over again. I would like to be able
to automatically test for a link at startup and if it exists, then disable
any link option, or else link the tables.

Thanks in advance

Damon

Reply to this Message

Douglas J. Steele - 20 Nov 2006 22:55 GMT

What code are you currently using? In essence, you can compare the current
Connect property to the desired linkage, and not relink if they're the same.
On the other hand, what difference does it make if the user insists on
relinking?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Is it possible to link tables at startup in code and test for links in the
> same code? I have the menu item "Link Tables" on the menu right now, but
[quoted text clipped - 5 lines]
>
> Damon

Reply to this Message