default query to snapshot

[Edwinah63]

i am about to release an access database (all tables and front end are
in ms access 2000), where certain trustworthy users wish to make their
own read-only queries for flexibility in reporting.

in oracle and ms sqlserver we can create read only views that the
users cannot change permissions on. the users can then link these
views to their access front ends and query from them.

What I am looking for is:

* to set the recordset type to snapshot for all users of Access 2000.
* this should happen for them whenever they create a query and not
have to do
it themselves. this means it must be globally set, not just manually
chaning the recordset type property for each query.
* a way of blocking the Query menu in query design mode so the users
cannot choose delete/update/append queries.
* is it possible to make access tables read only in access?? (sorry i
am an oracle person) on LINKED tables (ie the restriction is in the
client with the linked table, not on the base table itself)

i have googled around and it seems that other people have asked this
question and have not been answered.

i would appreciate any code or instructions on setting up a macro that
will allow me to achieve the above upon the user opening access.
all help appreciated

Edwinah63

[mariantrygg]

See Security settings - create a user group and give them read only
permissions on the tables you want them to have access to. Provided
they log on as a user who is a member of aforesaid group, they will
not be able to delete/insert/amend records in the tables you have
restricted.

You can also create menus and toolbars to give them only the commands
you want them to have access to. In startup code, you can check the
user name and set menus/toolbars accordingly, thus many people can
have all sorts of different types of access to your
tables/queries/code etc.

Hope this helps. There is plenty in the NG about security and how to
best go about it.

Marian

ed*****@customercare.com.au (Edwinah63) wrote in message news:<d7**************************@posting.google. com>...

i am about to release an access database (all tables and front end are
in ms access 2000), where certain trustworthy users wish to make their
own read-only queries for flexibility in reporting.

in oracle and ms sqlserver we can create read only views that the
users cannot change permissions on. the users can then link these
views to their access front ends and query from them.

What I am looking for is:

* to set the recordset type to snapshot for all users of Access 2000.
* this should happen for them whenever they create a query and not
have to do
it themselves. this means it must be globally set, not just manually
chaning the recordset type property for each query.
* a way of blocking the Query menu in query design mode so the users
cannot choose delete/update/append queries.
* is it possible to make access tables read only in access?? (sorry i
am an oracle person) on LINKED tables (ie the restriction is in the
client with the linked table, not on the base table itself)

i have googled around and it seems that other people have asked this
question and have not been answered.

i would appreciate any code or instructions on setting up a macro that
will allow me to achieve the above upon the user opening access.
all help appreciated

Edwinah63