[AccessD] Grab Filenames

Hi Doris,

Oops! You may well be right. I've set that DSN up on other 
user machines, but the machines I tested this on may not 
have been in that group. Thanks, I will check that asap.

Can you give me a pointer to the code that would check for 
and set the needed DSN up in code from Access?

Ron


On Wed, 21 May 2003 13:44:01 -0400
  "Mike and Doris Manning" <mikedorism at ntelos.net> wrote:
>Your problem lies in your connection string...
>"ODBC;DSN=db_pd1;UID=testuser;PWD=tu1234;DATABASE=CIRC"
>
>DSN "db_pd1" exists on your machine but probably doesn't 
>exist on the user
>machine.  In order for this to work, you will need to 
>create the DSN on the
>user machine.  You can have your code quietly check for 
>the presence of the
>DSN and create it if it doesn't exist without the user 
>having to do
>anything.