Printing form based on ADO Persisted Recordset in Access 2000

M

Mike

Has anyone had problems printing with a persisted recordset in MS
Access 2000? I'm opening a recordset from a SQL Server 2000 stored
procedure. Persisting the results and then loading (because I can't
seem to assign the recordset property directly against the stored
procedure maybe because of server-side cursors?).

Everything is fine with the form and requerying the form. But when you
go to file print, you get the message:
"The Microsoft Jet Database Engine cannot find the input table or
query: FILENAME.TMP. Make sure it exists and its name is spelled
correctly."

I've verified the file exists. I've also tried saving it to the root
to eliminate any Windows long file name issues.
Any feedback would be appreciated.

Thanks,
Mike
 
Top