I have an application with an Access front end, and a SQL Server back end. I have a stored procedure that exists in my SQL database. And a Passthrough query that calls the stored procedure in Access. However, everytime I run or call the passthrough query it asks for me to establish the connection to the database. Any help in correcting this would be greatly appreciated!

What kind of connection are you using (i.e. data source, link table, import...)?