SQL Server Performance Forum – Threads Archive
Reports with Access.Guys, how do I create repots for SQL2000 using Access? Thanks.
Use Linked Tables or a pass-through queries. Tom Pullen
DBA, Oxfam GB
Depending on your version of Access (2000 and above), you might want to create an adp project to paint your reports in Access.
Passthrough queries are usually more effecient than linked tables. Access can sometime be a resource hog for sql. Try to keep most of the processing in SQL itself and only return data that is required by the reports.
For larger databases or intensive requests, pass-through queries work better for this than linked tables. Depending on your version of sql, you might also consider reporting services for your reporting.