Application not giving desired results

[danny123]

Hi There
we have a ms access application which pools data from AS400.
we have scheduled it for every week but there is a situation when its missing the data to feed the tables.
but when we run the queries manually it gives the desired results.
all kind of response are welcome
Best
danny

 

[KeithG]

Are you using a ODBC driver to access the AS400 or are you exporting info from AS400 and then importing into Access?