Re: How to set up read-only accessibility to an existing .mdb



TechBoy <ronnolan@xxxxxxx> wrote:
> RE: Access 2002 SP3
>
> I have an app "App1.mdb" that has internal security built-in via a
> table: tblSecurity. In this table a match is obtained to see if they
> are authorized to use the app.
> This application has no Jet security being used ("Users/Groups", etc.)
>
> One of the requirements was to hide the DBWindow completely from the
> users, which works fine and the DBwindow is secure from all users.
> Another requirement for App1.mdb: the users need to create ad-hoc
> reports in the report designer area of this app.
>
> Is there a way to create a second .mdb "App2.mdb" that links to the
> tables in App1.mdb, but with purely read-only capability?
>
> Any counsel is appreciated.
>
> Thank you.

To do it properly you'd need to implement obviously workgroup security.
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response


.



Relevant Pages

  • How to set up read-only accessibility to an existing .mdb
    ... I have an app "App1.mdb" that has internal security built-in via a ... are authorized to use the app. ... One of the requirements was to hide the DBWindow completely from the ... reports in the report designer area of this app. ...
    (comp.databases.ms-access)
  • Re: Menu Bar Startup Options via VBA
    ... Tool/Startup/StartupOptions and click checkboxes to turn all the menus ... startup would prevent the power users from getting to the DBWindow. ... This app has some sensitive data in it. ...
    (comp.databases.ms-access)