Connecting via File DSN?

  • Thread starter Thread starter J
  • Start date Start date
J

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
 
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.
 
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)
 
Back
Top