Permissions For Exporting Reports

[Guest]

I have a user level secured Access 2000 database. The database has on average
7 concurrent users and has a number of reports of which some need to be
exported to MS Excel or Word (as RTF).

The database is split into two sections (File\File system) and no user
groups have permissions on the underlying tables. On the linked tables the
users have full permissions (this still does not allow them to open the table
directly) and access to the data is controlled by way of queries that have
the Owner Access option set on them. The users need full permissions on the
front end so that temporary tables can be created if needed and to also
re-link the tables using .Connect property of the TableDef object if the
database is moved.

All groups have read data access to the reports, however when they try to
export them via the menus or by code using the DoCmd.OutputTo, SendObject or
TransferSpreadsheet an error message is displayed stating that the user does
not have read permissions on table MsysAccessObjects. I have checked the
permissions and the users do have read permissions on the front end of the
database. I have also tried changing the permissions on this table, the base
table and on the queries to give full permissions but the error message is
still displayed. I have trawled the Internet for some information but there
is none. You can export to SnapShot Format but Not Excel, Text or RTF.

The problem appears to be something to do with the permissions on the back
end of the database. The error message is:

Record(s) cannot be read; No read permissions on "MSysAccessObjects";

I have added read permissions to the system table both in the front and back
end but this has no affect.

Does anybody have any theories please?

 

[Joan Wild]

The problem appears to be something to do with the permissions on the
back end of the database. The error message is:

Record(s) cannot be read; No read permissions on "MSysAccessObjects";

I have added read permissions to the system table both in the front
and back end but this has no affect.

First, you shouldn't change permissions on any system tables.

The message is usually an indication of corruption. See this thread

http://groups.google.com/[email protected]

 

[Guest]

Thanks for the help on this subject. I reverted the permissions back on the
system tables after I changed them.