P
Phil F
Hi -
I've got a fairly complex db for a hospital department up and running. The
staff would like the ability to do ad hoc queries, and a reasonable solution
seems to be to make a separate "QueryDB" with tables linked to the main db.
There isn't enough traffic to REQUIRE the querydb contain imported tables
rather than links to the live tables. (Maybe should do this anyway.)
But I am wondering, is there a way to specify that the linked table be read
only? I tried setting all the linked tables to read-only in
Tools/Security/User & Group Permissions, for the Admin logon. But even though
these settings "took" and seem to be in place, I can still edit the data.
We'd feel safer if the tables were readonly.
It is easy enough to make the queries I leave for them to be "snapshot"
rather than "dynamic". Is there a way to make the default for new queries
"snapshot"?
Many thanks,
Phil Freihofner
San Francisco
I've got a fairly complex db for a hospital department up and running. The
staff would like the ability to do ad hoc queries, and a reasonable solution
seems to be to make a separate "QueryDB" with tables linked to the main db.
There isn't enough traffic to REQUIRE the querydb contain imported tables
rather than links to the live tables. (Maybe should do this anyway.)
But I am wondering, is there a way to specify that the linked table be read
only? I tried setting all the linked tables to read-only in
Tools/Security/User & Group Permissions, for the Admin logon. But even though
these settings "took" and seem to be in place, I can still edit the data.
We'd feel safer if the tables were readonly.
It is easy enough to make the queries I leave for them to be "snapshot"
rather than "dynamic". Is there a way to make the default for new queries
"snapshot"?
Many thanks,
Phil Freihofner
San Francisco