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

[Rogue Petunia]

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

 

[Douglas J. Steele]

Easiest way is to create a DSN, then go to File | Get External Data | Link
Tables and change the Files of Type combo to ODBC Databases(). That will
bring up a dialog that will let you choose the DSN you just created. Once
you've done that, pick the tables you want, and you'll end up with links to
them in your Access database.

A better approach is to create Pass-through queries (better because they run
on the server, thereby are usually considerably faster, and reduce network
traffic)