Collectiong data from SQL server / Repeat!

  • Thread starter Thread starter Sh0t2bts
  • Start date Start date
S

Sh0t2bts

Hi I am using an macro to collect data from an SQL server, the problem I
have is if the server is locked "usally by someone connecting using access"
Iget an error massage saying that the SQL server is locked please try again.

is there a way of capturing this error and getting the macro to run the last
step?


Cheers

Mark
 
Usually, a SQL connection has a timeout associated with it. Can you
set the timout to a large number? Or, if you are sure you will
eventually connect, specify 'forever' as the timeout interval?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Hmmm

I don't state a timeout "time" so I am unsure, what tends to happen it it's
not a timeout but more of a bugger off this is locked / blocked try later.

I know that the guys who use access to connect cos they can't / don't know
hoe to use pass through queries are at fault but I have no way of stopping
them as it's there server :o(
Mark
 
Back
Top