Report Based on Pass Through Query

[Vaughan]

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)

 

[Rick Brandt]

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)

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.

 

[Vaughan]

Thanks Rick. That'll do the trick

Vaughan

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.