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.

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?