setting CommandTimeout for CurrentProject.Connection

D

Daniel

Hi,

I need to increase CommandTimeout but cant do this with
CurrentProject.Connection object.
The following code i tryed is:

CurrentProject.Connection.CommandTimeout = 90
CurrentProject.OpenConnection ConnStr, UserName, pwd

This doesn't do the job.
I also tried this -

CurrentProject.Connection.CommandTimeout = 90
CurrentProject.Connection.ConnectionString = ConnStr
CurrentProject.OpenConnection

nothing works.... :-(
 

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

CurrentProject.OpenConnection ignores default language 1
procedure timeout for report 3
VSTO C# add in Outlook.Appointment error 0
Automating reports in an .ADP from VB6 0
ODBC driver does not support the requested properties 0
Programmatically set UID & PWD in existing ODBC DSN connection string. 1
Get SQL authentication Name from SQL Server using access front End 0
Exporting Access table using a button click in exce 4

Top