I am having an issue with the RUMBA ODBC driver and Microsoft Access. I am using the RUMBA AS/400 Optimized Server 32 bit ODBC driver to connect to the tables of an AS/400 in Access. It works fine initially. The first time I connect Access prompts for my AS400 user name and password. It has never asked for my credentials again. Even when I create a new database and choose that ODBC connection. Normally this would be fine but I just had to chance my password on the AS400. Now the ODBC call fails because it seems to be using the old password. Does anyone know where this password data is stored and how I can reset it?
#RumbaPlease check in the Rumba AS/400 Communications (Rumba Tools)
Check if UserId & Password Caching is enabled.
I am having an issue with the RUMBA ODBC driver and Microsoft Access. I am using the RUMBA AS/400 Optimized Server 32 bit ODBC driver to connect to the tables of an AS/400 in Access. It works fine initially. The first time I connect Access prompts for my AS400 user name and password. It has never asked for my credentials again. Even when I create a new database and choose that ODBC connection. Normally this would be fine but I just had to chance my password on the AS400. Now the ODBC call fails because it seems to be using the old password. Does anyone know where this password data is stored and how I can reset it?
#RumbaThanks a ton, that worked.
