Kbase 18488: Error (91) when creating an ODBC schema holder against a MS Access database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/11/2005 |
|
Status: Verified
FACT(s) (Environment):
MS Access
ODBC DataServer
SYMPTOM(s):
Error (91) when creating an ODBC schema holder against a MS Access database
** No <file-name> record is available. (91)
More than one active procedure. Do not use default handle for <proc-name>. (2104)
The error appears after selecting the tables to pull into the schema holder
The Progress session crashes
When reconnecting to the schema holder, there is no tables created.
CAUSE:
In order to perform a schema pull using the ODBC DataServer, the user is required to have "Read Design" authority to the tables to be pulled. This permission is automatically assigned if the user is granted Read Data authority to a given table. At a minimum, "Read Design" permission is required for all users that will be performing schema pulls from an MS-Access database.
In conjunction, grant the appropriate read, insert, update, and delete permissions to those users who will be manipulating data within this database at run-time. The Progress DataServer relies on the appropriate permissions being granted in the underlying database in order to complete transactions against
the native database.
FIX:
In MS-Access you can access table permissions via the Tools-> Security->User and Group permissions menu option.
Make sure the "Read Design" authority is checked for the tables to be pulled.
If you are not able to change the permissions of a table because you do not have the authority to do so (not the owner, etc.) then you may simply
be able to make a copy of the table (edit->copy, edit->paste) so that you will have the authority to change permissions.
If you want to change the original table's permissions then you must have Administrator authority so that existing permissions on a table can be modified if the required permissions are currently missing.