can I use MS Access reports on SQL Server 2000 db?

Hi,
I have a SQL Server 2000 db on which I would like to perform querys and have
pretty reports printed. Can I use MS Access (for the pretty reports) to
connect to the SQL Server 2000 db? If yes, can you please tell me how to
set up the connection?
Thanks,
Rogue Petunia"Rogue Petunia" <roguepetunia@.NOSPAMnyc.rr.com> wrote:
> Hi,
> I have a SQL Server 2000 db on which I would like to perform querys and
have
> pretty reports printed. Can I use MS Access (for the pretty reports) to
> connect to the SQL Server 2000 db? If yes, can you please tell me how to
> set up the connection?
--
Hi Rogue,
You can use the Access ADP to link data from SQL Server. The Access ADP uses
OLE-DB to connect to SQL Server.
For more details, please consult your Access doco's.
Hope this helps,
-Eric Cárdenas
SQL Server support|||Hi Eric,
Totally lost. Don't know what ADP is. Looked in Access Help, can't find
ADP.
Further details appreciated.
Thanks.
"Eric Cardenas" <anonymous@.discussions.microsoft.com> wrote in message
news:3fce4bf3$1@.news.microsoft.com...
> "Rogue Petunia" <roguepetunia@.NOSPAMnyc.rr.com> wrote:
> > Hi,
> > I have a SQL Server 2000 db on which I would like to perform querys and
> have
> > pretty reports printed. Can I use MS Access (for the pretty reports) to
> > connect to the SQL Server 2000 db? If yes, can you please tell me how
to
> > set up the connection?
> --
> Hi Rogue,
> You can use the Access ADP to link data from SQL Server. The Access ADP
uses
> OLE-DB to connect to SQL Server.
> For more details, please consult your Access doco's.
> Hope this helps,
> -Eric Cárdenas
> SQL Server support
>|||"Rogue Petunia" <roguepetunia@.NOSPAMnyc.rr.com> wrote:
> Hi Eric,
> Totally lost. Don't know what ADP is. Looked in Access Help, can't find
> ADP.
--
Hi Rogue,
ADP stands for "Access database project." The other Access file is MDB for
"Microsoft database." IIRC, the ADP was introduced in Access 2000.
The difference in the ADP and the MDB is that the ADP contains no data. The
ADP is purposely designed to use SQL Server (or any OLE-DB source). The MDB
can store data using Access tables. The MDB uses ODBC to connect to SQL
Server.
What version of MS Access will you use?
Let me know if you need more information.
--
Eric Cárdenas
SQL Server support|||Eric,
A co-worker just showed me how to do it. Sort of like a variation of "a
picture is worth a thousand words" ;) Now it totally makes sense.
thanks anyway,
Rogue Petunia
"Eric Cardenas - ANZ MSFT support" <anonymous@.discussions.microsoft.com>
wrote in message news:3fce5657$1@.news.microsoft.com...
> "Rogue Petunia" <roguepetunia@.NOSPAMnyc.rr.com> wrote:
> > Hi Eric,
> > Totally lost. Don't know what ADP is. Looked in Access Help, can't
find
> > ADP.
> --
> Hi Rogue,
> ADP stands for "Access database project." The other Access file is MDB for
> "Microsoft database." IIRC, the ADP was introduced in Access 2000.
> The difference in the ADP and the MDB is that the ADP contains no data.
The
> ADP is purposely designed to use SQL Server (or any OLE-DB source). The
MDB
> can store data using Access tables. The MDB uses ODBC to connect to SQL
> Server.
> What version of MS Access will you use?
> Let me know if you need more information.
> --
> Eric Cárdenas
> SQL Server support
>|||You can also use an MDB. Base your reports on a pass-through query or
a query against a linked table/view.
-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446
On Wed, 3 Dec 2003 16:55:28 -0500, "Rogue Petunia"
<roguepetunia@.NOSPAMnyc.rr.com> wrote:
>Eric,
>A co-worker just showed me how to do it. Sort of like a variation of "a
>picture is worth a thousand words" ;) Now it totally makes sense.
>thanks anyway,
>Rogue Petunia
>
>"Eric Cardenas - ANZ MSFT support" <anonymous@.discussions.microsoft.com>
>wrote in message news:3fce5657$1@.news.microsoft.com...
>> "Rogue Petunia" <roguepetunia@.NOSPAMnyc.rr.com> wrote:
>> > Hi Eric,
>> > Totally lost. Don't know what ADP is. Looked in Access Help, can't
>find
>> > ADP.
>> --
>> Hi Rogue,
>> ADP stands for "Access database project." The other Access file is MDB for
>> "Microsoft database." IIRC, the ADP was introduced in Access 2000.
>> The difference in the ADP and the MDB is that the ADP contains no data.
>The
>> ADP is purposely designed to use SQL Server (or any OLE-DB source). The
>MDB
>> can store data using Access tables. The MDB uses ODBC to connect to SQL
>> Server.
>> What version of MS Access will you use?
>> Let me know if you need more information.
>> --
>> Eric Cárdenas
>> SQL Server support
>>
>