I have the following problem in an access 2000 adp project.

I am trying to open a connection in an access 2000 adp project using 

CurrentProject.OpenConnection "my connection string", i want to set a 

connection timeout of my own and not use the default. When i try 

CodeProject.Connection.ConnectionTimeout = 10, access tells me that the 

connection is open and thus ConnectionTimeout is read only. When i try to 

close the connection first using CurrentProject.CloseConnection i am 

getting a message that says close failed. Does any one knows how can i set 

the connection timeout in an access adp project before opening a new 

connection with code.



Thank you.