Connecting to SQL server without ODBC driver saved

A

Adam

Hi All,

I have a data repository which is saved on a SQL server connected to
our work network.

I have setup reports in Access which report from the sql server. Only
problem is that to run the reports you have to have the SQL server odbc
connection installed on that machine.

Is there a way where I can save the ODBC connection in the database so
any machine on the network can run the reports?

Many Thanks

Adam
 
P

Pieter Wijnen

sure
use dsn-less connections
check out
http://www.accessmvp.com/djsteele/DSNLessLinks.html
for the "howto"

Pieter


Adam said:
Hi All,

I have a data repository which is saved on a SQL server connected to
our work network.

I have setup reports in Access which report from the sql server. Only
problem is that to run the reports you have to have the SQL server odbc
connection installed on that machine.

Is there a way where I can save the ODBC connection in the database so
any machine on the network can run the reports?

Many Thanks

Adam
Click to expand...



--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Snowflake to SSIS 0
Access2010 redistribuible + runtime e ODBC issue 2
SQL Server connection 17
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
Connecting to SQL Server DB in Windows 7 1
Linking ODBC Tables for Multiple Users 7
ODBC Call Failed - Numeric value out of range 2
ODBC Connection String for SQL Server 3

Top