I'm having trouble setting report fields recordsource (in Access 2007 adp project) to an ADO recordset returned by SQL Server 2005 stored proc .
Access crashes when I tried to
Set Me.Recordset = rst on Report_Open
, and it produces the following error message:
Microsoft Office Access has encountered a problem and needs to close. We are sorry for the inconvenience.
What is the cause of this error, and how can I resolve it?
Thank you in advance,