Changing Access ID and Access Password
If you need to change the both Access Id and Access Password follow the following steps.
UPDATE PSSTATUS SET OWNERID = ‘ACCESSID’
UPDATE PSACCESSPRFL SET ACCESSID = ‘NEW_ACCESS_ID’, SYMBOLICID = ‘SYMBOLIC_ID’, ACCESSPSWD = ‘NEW_ACCESS_PASSWORD’, ENCRYPTED = 0
This AccessID should have dbo access when it created on database server.
Note: No need to encrypt this, when you open the application designer first time, it will automatically encrypt and update the PSACCESSPRFL table.
If you need to change the access password, change the password for that user at the database level and open Application Designer then go to Miscellaneous Definitions - > Access Profiles.