>Yep, that's what I figured. I've done tow things to set up the connection:
>
>(1) I created a File DSN.
>
>(2) I created a DBC Connection.
>
>Neither seems to do the job and I cannot open the file automatically without that OPEN FILE dialog box appearing every time wanting me to find the MDB that is already defined as said in the above two places.
>
>I may have to create the Connection on the fly with SQLSTRINGCONNET()?
>
>Cecil
>
>>If you can't open the view with USE in a command window, something's missing. With ODBC and remote views, you have two basic choices:
>
>>- include connection information as part of the Remote View definition, stored in the .DBC
>>- create your connection on-the-fly
>
>>Assuming the former, you might want to check that your connection string is complete. One good resource is
http://connectionstrings.com/ .
Have you checked that your connection string is complete, at the site I referenced?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up