I
Ian Kayser
I am wondering how one would call the linked tables applet with out pressing
file, external data, linked files.
file, external data, linked files.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Roger Carlson
You can use the acCmdLinkedTableManager constant of the RunCommand :
Put this:
RunCommand acCmdLinkedTableManager
in the code behind a button, for instance.
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
Put this:
RunCommand acCmdLinkedTableManager
in the code behind a button, for instance.
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
R
Roger Carlson
BTW, I don't use RunCommands much, but here is a useful website concerning
them:
http://www.tkwickenden.clara.net/index.htm
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
them:
http://www.tkwickenden.clara.net/index.htm
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
I
Ian Kayser
Thanks Roger.
Why don't you use runcommands?
Ian.
Why don't you use runcommands?
Ian.
R
Roger Carlson
Personal preference mostly. The RunCommands allow you to automate the
Access GUI (graphical user interface). However, this is limited if you ever
run your database in the Runtime environment and I am called to do that
occasionally. So I usually use VBA to create my own interface functions,
thereby not relying on the built in interface.
So in your case, I would create my own relinking function. In fact, on my
website (www.rogersaccesslibrary.com), is a small Access database sample
called "RelinkOnOpen.mdb" which does just that. It's not a general as the
Linked Table Manager, but it links the actual tables I have, which is all I
need for a particular application.
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
Access GUI (graphical user interface). However, this is limited if you ever
run your database in the Runtime environment and I am called to do that
occasionally. So I usually use VBA to create my own interface functions,
thereby not relying on the built in interface.
So in your case, I would create my own relinking function. In fact, on my
website (www.rogersaccesslibrary.com), is a small Access database sample
called "RelinkOnOpen.mdb" which does just that. It's not a general as the
Linked Table Manager, but it links the actual tables I have, which is all I
need for a particular application.
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
R
Roger Carlson
On, and there's another sample called "LinkTables.mdb" which shows how to
change the link from one database to another.
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
change the link from one database to another.
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L