Access System Tables Permissions through ODBC

[Carlo]

Hi,

I'm trying to read the user table names within an Access DB from an external
application through ODBC.
I query system table "MSysRelationships", when I do that locally (in Access)
it works fine. But when I try
to do that remotely I get this error: [Microsoft][ODBC Mircosoft Access
Driver] Record(s) cannot be read;
no permission on 'MSysRelationships'.

How can I set the permissions to also access this system table?

Carlo

 

[Larry Linson]

It was not for naught that Microsoft deemed it unsuitable to publish the
specifications for the System Tables -- as there have been some changes to
the System Tables in each release of Access. Instead, they provided an
Object Model, accessible via DAO code, that has been quite reliable to
access and manipulate the content of the Object Model.

Various pundits have demonstrated their special knowledge by writing about
the System Tables, and others of us have sometimes used the System Tables,
but it is NOT good practice -- it is better to use the published Object
Model and DAO or ADO code, in VBA, to work with the Objects.

Larry Linson
Microsoft Access MVP

 

[Guest]

I'm not aware of any specific limitations here. Try it
again, making sure you know which workgroup and
user name is actually in use before attempting to read
the table. Add extra permissions to the table as required.

(david)

 

[Carlo]

Thanks Larry!

Just the fact that you mentioned ADO, put me on the right track again.
It's all working so much smoother now!

Carlo

It was not for naught that Microsoft deemed it unsuitable to publish the
specifications for the System Tables -- as there have been some changes to
the System Tables in each release of Access. Instead, they provided an
Object Model, accessible via DAO code, that has been quite reliable to
access and manipulate the content of the Object Model.

Various pundits have demonstrated their special knowledge by writing about
the System Tables, and others of us have sometimes used the System Tables,
but it is NOT good practice -- it is better to use the published Object
Model and DAO or ADO code, in VBA, to work with the Objects.

Larry Linson
Microsoft Access MVP

Hi,

I'm trying to read the user table names within an Access DB from an
external application through ODBC.
I query system table "MSysRelationships", when I do that locally (in
Access) it works fine. But when I try
to do that remotely I get this error: [Microsoft][ODBC Mircosoft Access
Driver] Record(s) cannot be read;
no permission on 'MSysRelationships'.

How can I set the permissions to also access this system table?

Carlo