Read-only access to reports...in a separate DB

J

JF

Hello all,

I have an Access application that houses "canned" reports in a separate MDB
file for various reasons. Users are allowed to open these reports and
modify them, but they can't save them as the same name - they have to "Save
As...".

Originally these reports were in the same MDB as the application. To make
them read-only, they were created while using a certain user account. Then
when opening the application, a different username is used which disallows
write access to the reports.

However, I can't seem to find a way to duplicate this now that the reports
are separated into the new mdb. FYI, to get the reports to work in the
separate DB, I have the reports MDB as a reference in my original
application. I've tried using the "username" method described above, but it
seems to be ignored - perhaps because the reports MDB is just a reference.

Can anyone offer a suggestion on how to get this to work?

Thanks,

JF
 
Top