I'm using an Access 2002 ADP (Access Data Project).

I set the RecordSet property of my form from an ADO resultset in code, and I've noticed that it puts the stored procedure call in the RecordSource property of the form. The results display fine.

However, after leaving the form for a few minutes and error message pops up telling me that the form's record source no longer exists (and shows the SP name with ?'s for the parameters - "{call prMyProcedure (?, ?)}"). All my fields then show #Name# because they can't find any data.

There is obviously some sort of timeout happening - what is it, and how do I stop it?