Have Linked Table Manager run at DB Open

[Mary]

Is there a way to code the linked table manager to run when the datbase is
opened?

Thanks

 

[Keven Denen]

Is there a way to code the linked table manager to run when the datbase is
opened?

Thanks

If you really want to do this, you can use: RunCommand
acCmdLinkedTableManager. Put that on the open event of whatever your
startup form is.

If you are trying to make sure you relink your tables, check out this
post: http://www.mvps.org/access/tables/tbl0009.htm. It shows how you
can use code to do this automatically without using the linked table
manager.

Keven

 

[Mary]

Keven
Thank you

If you really want to do this, you can use: RunCommand
acCmdLinkedTableManager. Put that on the open event of whatever your
startup form is.

If you are trying to make sure you relink your tables, check out this
post: http://www.mvps.org/access/tables/tbl0009.htm. It shows how you
can use code to do this automatically without using the linked table
manager.

Keven

 

[Tom Wickerath]

Another alternative to using the code shown on the MVPS.org site is to
download the free J Street Relinker tool, available from Access MVP Armen
Stein:

http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________