Troubleshooting
Problem
User logs into database through iBase Designer or User and when they log off and attempt to close the program, the are confronted with a Data Access Control error.
Symptom
"You have altered some Data Access Control settings; which will have affected the integrity of the following database(s): ....."
Cause
The reason this error usually appears is a user has made certain changes in the Data Access Control settings in iBase Designer and is being prompted to update these settings by logging into the mentioned database.
However, if this does not resolve the issue, then the error is caused by the fact they have recreated the database in question i.e. they have created a new .IDB file and then restored a SQL backup file over the top of a new SQL database.
Environment
IBM i2 iBase 8.9.5
Resolving The Problem
To get rid of this message the user will need to create a registry key, on the system administrator user's machine. They will need to follow these steps to accomplish this:
1. Open the registry editor and go to HKEY_CURRENT_USER\Software\i2\iBase\8\UserSettings
2. Create a new String Value in this section called:
AllowDBUnregisterDAC
3. Set the Data for this new String Value equal to "1".
4. The system administrator user will then log on to the security file and then log off again.
5. This time when the message appears, there will be another option available which will allow the user to unregister the database causing the issue. They need to answer "Yes." The error will no longer appear after this when they attempt to close out iBase Designer or User.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21651769