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