D
Doug
Hi,
I've created an Access mde database in Access 2000 and have secured it using
the user-level security wizard. I have (amongst others) a group with
read-only permissions on all existing tables and queries. This is fine for
the existing objects as users can view the data and structure but can't
modify either of them.
However... I want to prevent these users from creating new queries but
haven't found a way. I have tried giving them no permissions on thew
tables/queries in the permissions applet but that doesn't work. I guess
that the permissions are applied after the query is created and by that time
they are the owner and so automatically have permissions?
Is there any way to make a database genuinely read-only to a group of users
so that they can view data and run queries but not create any objects? My
db has no modules, forms or reports, only tables and queries.
Thanks in advance,
Doug
I've created an Access mde database in Access 2000 and have secured it using
the user-level security wizard. I have (amongst others) a group with
read-only permissions on all existing tables and queries. This is fine for
the existing objects as users can view the data and structure but can't
modify either of them.
However... I want to prevent these users from creating new queries but
haven't found a way. I have tried giving them no permissions on thew
tables/queries in the permissions applet but that doesn't work. I guess
that the permissions are applied after the query is created and by that time
they are the owner and so automatically have permissions?
Is there any way to make a database genuinely read-only to a group of users
so that they can view data and run queries but not create any objects? My
db has no modules, forms or reports, only tables and queries.
Thanks in advance,
Doug