ODBC Call failed

[jmr6_99]

I have a report that runs automatically every morning (work related project), However, probably half of the time, when it runs I receive an ODBC call failed message -- and the MS Access help is not very useful. If I run the report again I can get it to work. Can anyone offer any insight into what this error might mean and how I can permanently correct it.

Thanks,
Joe

 

[crosmill]

Maybe the 'other end' of the ODBC link is locked/unavailable at the time.

If the the report is run automaitcally maybe it's not quite compleating one step before it starts another, try breaking it down.

You can maybe code some error trapping into it, so if it fails, it keeps trying until it succeeds.

 

[crosmill]

Hello,

I was wondering if you could give a little more detail about how I might code error trapping into my report -- so that if it fails it keeps trying until it succeeds.


Any additional info would be most appreciated.

Thanks

I don't really know that much about the OnError part coding functions but I know it exists. If you set a button to perform a command like running a query then look at the code access writes for it you'll be able to see the syntax for the OnError.

Basically though, you just say OnError Loop back tot he beggining

 

[jfgambit]

Joe,

In the Properties of the Query, what is the ODBC Time-out set at?

I used to get this if the Time-out was not set correctly. Access defaults it to 60 seconds. To set it to run with no time limit change it to 0.

See if that helps.