Access Project / SQL Server Connection Timeout Problem

Hello,

I have an Access .adp file that's connected to a SQL Server. I can run small queries just fine, but some of my queries take several minutes to run. When I try to run a lengthy query I get an error message that says "Timeout Expired".

I believe that this error is the one that is described here on MSDN online:

http://support.microsoft.com/kb/243464


I tried to implement a solution similar to this in .adp file by creating this subroutine:

----------------------------------------------

Sub BypassTimeout()

CurrentProject.Connection.CommandTimeout = 0

MsgBox "The subroutine ran"


End Sub

-----------------------------------------------

I know that the subroutine is running because I'm seeing the message in the MsgBox statement. (This sub runs everytime the .adp file is opened).

However, doing this still doesn't seem to prevent me from getting the "Timeout Expired" error message when I try to run a lengthy query.

Does anyone know a way around this? I believe the default timeout is 30 seconds ... but SURELY microsoft did not intend for .adp files to not be able to run queries that are longer than 30 seconds.