Kbase 21882: Error 43 -- Windows XP & User Rights with Progress Database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/03/2002 |
|
SUMMARY:
Progress software is normally installed on Windows using a local Administrator account. On Windows XP, when databases are created by the local Administrator account, users that are properly registered on the XP system do not have access rights to the database files.
The error that appears when a user tries to connect to a database created by a local Admin account is:
Cannot find or open file (path to the database) errno = 5 (43)
Errno = 5 on Windows means "access denied."
EXPLANATION:
On Windows XP, users are given "Read/Execute" rights to the database but not "Write" access. Users need "write" access.
SOLUTION:
The short-term solution is to change the access rights of a user to the database. The long term solution is to properly configure user groups with access rights to the database.
To change a user's rights:
1) Log into Windows XP as local Administrator.
2) Go to the working directory where the database resides.
3) Highlight the database files (.db, .bi, .lg, .ai).
4) Right-click with the mouse and select "Properties".
5) Open the "Security" menu.
6) In the User and Group Name box, highlight the user.
7) In the Permissions box, select "Write" access for the user.