Category: Computers > Programming
Asked by: bselltiz-ga
List Price: $20.00
24 Feb 2004 14:56 PST
Expires: 25 Mar 2004 14:56 PST
Question ID: 310438
I need to determine, using code, if a table in any given database is linked or native to that database. Is this possible?
Re: Access Table
Answered By: hammer-ga on 25 Feb 2004 06:46 PST
Hi Brian, There are several articles at the MVPS Access Web that will help you. They include subroutines for relinking tables in code, listing linked tables, checking to see if tables are linked or local, checking to see if a table exists in the remote database, etc. Relink Access tables from code This topic includes a set of very handy functions and subroutines. http://www.mvps.org/access/tables/tbl0009.htm Retrieve linked database namepath http://www.mvps.org/access/tables/tbl0007.htm Relink tables from different datasources http://www.mvps.org/access/tables/tbl0012.htm Dev Ashish writes excellent code. I'm sure that these routines will get it done for you. - Hammer
rated this answer:
Hey Hammer, Looks like the second example is what I am looking for. I won't be sure until next week as I have to leave on an unexpected trip and won't be back until next Wednesday. None the less, thank you very much for the answer, glad to see you're still working the board. :->
|There are no comments at this time.|
If you feel that you have found inappropriate content, please let us know by emailing us at firstname.lastname@example.org with the question ID listed above. Thank you.
|Search Google Answers for|