Software

Ask something
Discussion Locked

Refreshing database from AS 400

0 helpful
2 replies

by zinka.topolcnik

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hay everyone!

I will in few words describe what problem I have.
I made a database that is connected with AS 400 system where is our major data. But, everytime I access this databese is needed to manualy refresh data from AS400 and cause sign-on to AS400.
In future, with this database will work a person who don't need to see what is going on in background. Thatfore, I want to make a button on my form that will run this refreshing from AS400 and show th eperson if there is some record that is new(not in ACCess).I had made a user for thhis person , exactly for ODBC , that password is saved and never prompted again but I don't know hoe to make this automatic refreshing.

I will appreciate if anyone know or have a suggestion about that.
Thank you in advance,
Zinka

2 replies

by shelleydoll

Try setting up a cron script on your AS400 to periodically refresh regardless of whether the data has changed or not.

Not sure I understood the question, but I hope that helps.

by zinka.topolcnik

Thank you , but I am not so good with AS400 and I don't know what is cron script.
Would you be so kind and explain me or suggest me the bok where I can find it.

Thanks again,
Zinka

This discussion is closed to new replies.