Folder Location in VB Script

[pb]

I have a custom form in OL2k. I pull records from a MS
access database. Is there anyway to reflect changes in
the VB Script to automatically find that database? What
I'm trying to do I send this form to some co-workers. But
they might save the attached database (which the form
uses) to a different location. How can the VB script
automatically adjust to that folder location?
..

 

[Sue Mosher [MVP]]

You could store the database location in a text field on the form, so that the user can change it if they put the database somewhere else. Your code would, of course, need to use the value of that property to connect to the database.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers