Sub forms linked to a Stored procedure times out?

R

Roy Frye

I have a Access Project in which there are some subforms' recordset that are
tied to a stored procedure. The subforms are in the Datasheet format and
normally contain multiply records. After a few minutes a message will appear:
The Record Source {Stored Procedure Name} Specified on this form or report
does not exist. Then the data in the sub is replaced by #Name (I think). I
have tried different variations with recordset types and other settings, but
nothing has worked yet.
It seems like the link is timing out in either Access or Sql Server.

Any help would be much apprieciated.
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multi-table select stored procedure subform ole eb error 2
how to code a button to export results of stored procedure to excel file 0
SQL Server Stored Procedure timeout 3
Sub forms keep turning out like tables 2
Stored procedure recordset not opening 9
Running a stored procedure from Access form 1
Access can't find stored procedure after scripting on sql server 2
Access Data Project, Dlookup() and A stored Procedure 1

Top