Kbase P136340: MS Access gives authorization failure error with linked tables
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/10/2008 |
|
Status: Unverified
SYMPTOM(s):
error 7677 accessing linked table.
permission denied (7677)
[DataDirect][ODBC Progress Driver][PROGRESS] Permission denied(7677)(#-20121)
SQL-92 connection to Progress database via MS Access.
FACT(s) (Environment):
Windows
Progress 9.1X
CAUSE:
Recently changed table owner
CAUSE:
Two queries are actually used. The table owner of one of the queries has not changed correctly
FIX:
Correct owner to the affected table