Connecting MSACCESS Frontend to MSSQL backend

[Guest]

Hello,
I have a question regarding connection two databases. Basically, I
have an access frontend peice which currently connections to an Access
backend. We are converting the backend to SQL. I have looked in the help in
Access but have not had much help to this point. I saw about the linking
tables option, or do I need to create a new ODBC? Thanks for the help!
- Bill

 

[Van T. Dinh]

Either creating DSN (Data Source Name which make the SQL Database accessible
on your computer as an ODBC Database).

This is part of the Operating System, not Access. Hence, you have to check
the Help of the O.S.

 

[Van T. Dinh]

The second alternative is to use DSN-less connection per Douglas J. Steele's
article:

http://www.accessmvp.com/djsteele/DSNLessLinks.html