Access 2003 adp and SQL Server 2000 connection issues

I have a well established Clent based recoding system using Access 2003 adp fronthend with SQL Server 2000 database.
All is working absolutely fine. Some users us terminal services, and some have stand alone PC.. Totally irrelevant for this problem..
Sometimes, and in particular every morning (and I mean every morning) a report using a stored procedure will fail on what looks to be a timeout.
The 1st person in in a morning always runs a report. Which always fails at least once before working. If they happen to be the 2nd person in, it appears to work OK.

The report is run via an access form of selection criteria, which opens an access report which uses a stored procedure (with parameters) as its record source. (Something I do a lot)

I do not program the connection to the data base, but as part of a user logging on they access tables to verify user names and security etc so I though that would be enough to establish a connection.

Does any one know why the reports seem to timeout. AS I said it always happen for ther 1st person logging on, but it can happen sporadically to anyone.

Anyone have any ideas
Here's my recordsource code

strRecordSource = "Exec [Sp_Case_Status] '" & _
                        [Forms]![frm_rep_Case_Status]![str_from_lender] & "', '" & _
                        [Forms]![frm_rep_Case_Status]![str_to_lender] & "', '" & _
                        [Forms]![frm_rep_Case_Status]![str_from_plan] & "', '" & _
                        [Forms]![frm_rep_Case_Status]![str_to_plan] & "', '" & _
                        [Forms]![frm_rep_Case_Status]![str_from_loan] & "', '" & _
                        [Forms]![frm_rep_Case_Status]![str_to_loan] & "', '" & _
                        [Forms]![frm_rep_Case_Status]![str_from_date] & "', '" & _
                        [Forms]![frm_rep_Case_Status]![str_to_Date] & "', '" & _
                        [Forms]![frm_rep_Case_Status]![str_status] & "', '" & _
                        [Forms]![frm_rep_Case_Status]![str_from_proc] & "', '" & _
                        [Forms]![frm_rep_Case_Status]![str_to_proc] & "', '" & _
                        [Forms]![frm_rep_Case_Status]![str_sort] & "'"
Start Free Trial