Google Answers: Access 97 - Updating Linked Tables through VBA

View Question

Q: Access 97 - Updating Linked Tables through VBA ( Answered 3 out of 5 stars

, 0 Comments )

Question

Subject: Access 97 - Updating Linked Tables through VBA
Category: Computers > Programming
Asked by: softcom-ga
List Price: $10.00

Posted: 17 Dec 2002 16:33 PST
Expires: 16 Jan 2003 16:33 PST
Question ID: 126233

I have a Access 97 database that has a about 15 linked tables.  I need
some VBA code that loop through all the tables in the database and if
it's a linked table, then it will update the link with a new path - it
will be the same path for all the linked tables. The database filename
will never change, only the path.

Answer

Subject: Re: Access 97 - Updating Linked Tables through VBA
Answered By: hammer-ga on 18 Dec 2002 05:24 PST
Rated: 3 out of 5 stars

This is answered at an excellent Access FAQ site.
http://www.mvps.org/access/tables/tbl0009.htm

The home page for the FAQ is:
http://www.mvps.org/access/

I recommend you bookmark this site. It's a great source for Access information! 

Good luck with your project.

- Hammer

softcom-ga rated this answer: 3 out of 5 stars

Thanks for the assistance.

Comments

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.

Search Google Answers for

Google Home - Answers FAQ - Terms of Service - Privacy Policy