Jump: Search for: 

Free Resources from FMS

 

Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.

Darren D.

 

 

 

 

Verify Linked Tables in Your Microsoft Access Application

Provided by: FMS Development Team

Ever had a user move a backend Microsoft Access database or delete it? Here is a routine you can use to ensure that the linked table actually exists in the location specified using ADOX.

You should be able to cut and paste everything from the "Begin Function" line to the "End Example" line into a new module and have it work for you.

Required References: ADO Extensions for Data Definition Language and Security (ADOX)


Sample Code

Return to the tips page

 

Feedback

Contact Us  l   Web questions: Webmaster   l   Copyright © 2010 FMS, Inc., Vienna, Virginia
Celebrating 24 Years of Software Excellence