Report via ODBC

[The Rook]

I have set up an ODBC link to our manufactuing System and have created
several reports.

What I am wanting to do is allow users to veiw or print these reports but
not via my ODBC link.

In other words a shortcut on their desk top to the report. I have tried to
do this but can only seem to create a shortcut to the ODBC link through
access.

Can anyone help?

 

[Rick Brandt]

I have set up an ODBC link to our manufactuing System and have created
several reports.

What I am wanting to do is allow users to veiw or print these reports
but not via my ODBC link.

In other words a shortcut on their desk top to the report. I have
tried to do this but can only seem to create a shortcut to the ODBC
link through access.

Can anyone help?

Your report needs data. It is getting that data via the ODBC link. If a user
without that ODBC link tries to run the report, no data will be available so the
report will fail.

You could make a static copy of the report in either Snapshot or PDF format and
let users link that, but if you want the report to automatically update then
they need that same ODBC link set up on their PC.

 

[The Rook]

Thanks,

If I set up the ODBC link on their computers can I restrict it so they can
only access the report and nothing else?

 

[Rick Brandt]

Thanks,

If I set up the ODBC link on their computers can I restrict it so
they can only access the report and nothing else?

No. You might be able to set up a DSNless connection using code in the report
and then use an MDE for them to view the report so they cannot see that code.
However; if the connection allows them access to data then anyone who knows how
will be able to create their own ODBC connection to the same data. On the
server you should be able to restrict that access to read-only though.