Can't find stored procedure

J

j_sobecki

Hi all, I'm currently using a pass-through query to access a stored
procedure in an Access database. The results of said stored procedure
is used as the recordsource of a subform displayed as a continuous
form. The problem is, when I open the form, it works exactly how it's
supposed to, but when I close the form and reopen it I get an error
stating that there is an ODBC error and that it cannot find the stored
procedure. The pass-through will not work until I update the
connection string (which is still correct) in the query, close the
database, and reopen the database. Can anyone point me in the right
direction? Thanks
BTW, I'm using SQL Server 2000 and Access 2002.
 
J

j_sobecki

This may a Form issue, because this problem seems to be occuring when I
open the main form from a login window. If I open the main form
directly, the stored procedure seems to run ok. Any ideas?
 

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

SQL Stored Procedure 1
stored procedure query 4
Access pass-through query to Oracle 10g stored procedure - results 1
"Compile error in table level validation expression " after format 0
Access ADP Form and Stored Procedure as RecordSource 0
Help with calling Stored Procedure on SQL Server 5
open SQL store procedure from adp 0
Old question regarding Access Templates. Any up to date answers, please 2

Top