Kbase P48936: Authorization Failure error when connecting via MS Access
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/25/2009 |
|
Status: Verified
SYMPTOM(s):
"Authorization Failure" error accessing linked tables from MS Access
Access denied(Authorization failed) (7512)
FACT(s) (Environment):
SQL-92 connection to Progress database via MS Access
The user has correct privileges for the table.
Session has two table links each connecting as a different user.
Windows NT 32 Intel/Windows 2000
Progress 9.1x
OpenEdge 10.x
Microsoft Access 2000
CAUSE:
MS Access client uses the first login information entered within the session.
FIX:
Exit and restart MS Access so that the saved login information within the link table will be used.