By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,224 Members | 1,630 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,224 IT Pros & Developers. It's quick & easy.

Timeout expired Access 2000 project on execution of long Stored Procs

P: 18
Hi everyone

I know a lot of people have this issue and have Tried changing the timeout in connection properties, but has anyone ever found a solution to this apart from run these at the server in Query Analyser?

Regards

Gary
Jun 23 '09 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,707
There is a .QueryTimeout property of the database that you can use to set the default for the whole database.

Changing the setting for a particular QueryDef would refer to .ODBCTimeout instead.
Jun 23 '09 #2

ADezii
Expert 5K+
P: 8,679
@garyb2008
You can try the CommandTimeout Property of an ADO Command Object. By setting this Property to zero, you are telling ADO to wait indefinitely until the execution is complete.
Jun 24 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.