Connecting via File DSN?

[J]

Greetings All

I'd like to create an access 2003 db that connects to
a file dsn. The file dsn is already set up to access a sql
server. I've tried lots of snippets today but have not had
any luck. Please help.

J

 

[Van T. Dinh]

When you set up the DSN, you normally have the option to test the
DSN/connection at the end.

I am not too sure about *File* DSN??? All of my ODBC DSN to SQL Servers are
"Sytem" DSN. I am sure "User" DSNs are OK also but don't know about "File"
DSN.

 

[david epsom dot com dot au]

After testing the DSN, try relinking using Tools |
Add-ins | Relink Manager, or File | Get External Data.

When you've got that working, then have a go with
the code.

(david)