AS/400 Profile getting disabled by MS Access

5 pts.
Tags:
iSeries
Microsoft Access
ODBC
We continue to have an issue where an AS/400 profile gets disabled by MS Access. This only happens sporadically (i.e not with the daily or hourly run of the scheduled tasks/jobs on the windows server). We are using ODBC linked tables to pull data from a couple of AS/400's in to MS Access. The other interesting thing is the disablement only occurs on one of the 400's not the other. Any ideas?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Is this profile shared by a user who may be disabling it by exceding the sign-on attempts?
We have some user that have macros set up to log them in and they forget to change them
when they are forced to change their password.

If this profile is not shared, you may consider changing the pasword to not expire and the number of signon attempts to something larger.

Is it possible there may be an unauthorized user trying to access your system?
If you are using the same profile to access multiple as/400′s it sounds like system value or setting may be slightly different for the profile.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    What job is logged as the disabling job? Is the remote source from the device making the OBBC calls? Does the time match with expected accesses? What is the cause that is logged? Tom
    125,585 pointsBadges:
    report
  • Rickmcd
    Could it be the ODBC User Profile has a expired password?
    1,605 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following