H
Harry
Hi everyone
I am trying to call an ms access report from either TSQL SP or Function
Can anyone help i have tryed two other groups and the last group told me to
try here.
To read full story read on....
Oh boy! Big question here.
It's a certainty that while it's theoritically possible to open a report by
using Access' Automation (with maybe a combination of SendKeys), doing so
directly from a SQL-Server procedure is probably a good recipe for trouble
or even disaster. The report features of ADP are very similar to those of
MDB files; so probably you can ask in the m.p.a.reports newsgroup how to do
this; however, this is path that personally, I would never travel.
IMHO, you would be in a much better position to use any other method of
generating a report than calling Access using Automation directly from
SQL-Server.
I am trying to call an ms access report from either TSQL SP or Function
Can anyone help i have tryed two other groups and the last group told me to
try here.
To read full story read on....
Oh boy! Big question here.
It's a certainty that while it's theoritically possible to open a report by
using Access' Automation (with maybe a combination of SendKeys), doing so
directly from a SQL-Server procedure is probably a good recipe for trouble
or even disaster. The report features of ADP are very similar to those of
MDB files; so probably you can ask in the m.p.a.reports newsgroup how to do
this; however, this is path that personally, I would never travel.
IMHO, you would be in a much better position to use any other method of
generating a report than calling Access using Automation directly from
SQL-Server.