Quick Find: Search for:
Free Resources
from FMS
 

Demos

Email Newsletter

Technical Papers

Tips and Techniques

Links

Book Recommendations

View all FMS products for Microsoft AccessMicrosoft Access Resource Center

 

 

"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 Application

Provided by: FMS Development Team

Ever had a user move a backend 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.

Questions  l   Web questions: Webmaster   l   Copyright © 2008 FMS, Inc.

Celebrating 21 Years of Software Excellence