Access 2007, SP3 connected to SQL Server 2008.

Summary: Report is not displayed when run from a user's account, but report is displayed when run from an Admin account.

We'll call the report the "Green" report.

1. User opens Access.
2. User open Main form.


3. User selects report parameters and keys in report parameter.
4. User clicks on button to generate report.
5. Report_Open event handler grabs the report parameters from the two drop down lists and a text box, builds a SQL statement to invoke a stored procedure: "EXEC ReportGreen P1, P2, P2", and sets RecordSource to SQL statement.
6. SQL runs the stored procedure. Access displays hourglass.
7. SQL returns a result set. Hourglass changes to a pointer cursor.
8. Green Report is not displayed.

I ceated Report_Open and Report_Load event handlers and set breakpoints in these handlers. The breakpoints are not hit.

I monitored the execution of the report stored procedure in SQL profiler. I see the report SP being started and then completing 30 seconds later.

What's odd is:

* The user can run all of the other reports I've created for them from their user account.

* I can generate the Green report from my Admin account on the client's server.

If I run the Green report SP from SQL studio it takes ~2 minutes and returns ~264 records.

Any ideas on what the problem is or ideas on how to debug?

Ed