time out

[jtwork]

I have a query i pull from access which is on a loop of about 1.5 mins which recreates this import each time. Sometimes it freaks out and crashes and i think its because of the timeout is set to 5

Would i be right in thinking that if it took longer than 5 seconds this could happen and if i increase to say 20 then i should be ok.

It only crashes out a few times a day


"ODBC;DSN=MS Access Database;DBQ=C:\Plasma\Hourly_Update.mdb;DefaultDir=C:\Plasma;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTi" _
), Array("meout=5;")), Destination:=Range("A1"))

[jtwork]

anyone got any ideas with this?

I tried changing to 20 seconds but it still crashed out over the weekend