Report Based on Pass Through Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access doesn't seem to be able to cope with a report based on a pass-through
query. Editing the query is virtually impossible, with the simplest action
taking up to a minute to register. Saving the (relatively simple) report
definition sometimes takes five minutes or more and often crashes in the
middle.

Is there anything I can do about this?

Thanks

Vaughan

(Office 2003, pass through query to MS SQL Server)
 
Vaughan said:
Access doesn't seem to be able to cope with a report based on a
pass-through query. Editing the query is virtually impossible, with
the simplest action taking up to a minute to register. Saving the
(relatively simple) report definition sometimes takes five minutes or
more and often crashes in the middle.

Is there anything I can do about this?

Thanks

Vaughan

(Office 2003, pass through query to MS SQL Server)
Click to expand...

Create a temp table with the same field names and set your RecordSource to that
while you are working on it. Change to your query when finished.
 
Thanks Rick. That'll do the trick

Vaughan

Rick Brandt said:
Create a temp table with the same field names and set your RecordSource to that
while you are working on it. Change to your query when finished.
Click to expand...
 
Back
Top