I am attempting to write a simple VB6 application that will create an instance of Access, open a database, and export a table using export specifications within the same database. The code works if I am in Access (97), but I get an error saying the spec does not exist if I try to run from the VB6 app. I've checked references, tried hard-coding the names of the specs, but nothing seems to work. Has anyone encountered something like this before, or have any ideas for me to try?

Thanks, and Happy Holidays!

------------------
Sherri T.