Permission only to insert via forms.

  • Thread starter Thread starter coja
  • Start date Start date
C

coja

Dear all,

I am currently learning to work with Access 2003 by
creating a database for a clinical trial. As being the
administrator, I am now trying to give permissions to
certain data entrists. The only permission I want to give
them is to insert by using the forms I have created.
However, according to the book I have (MS Office Access
2003 Bible) this is not possible ?
According to the book, the closest thing is 'Insert data'
for tables and queries. However, when I check that box,
the 'Read data' and 'Read design' are automatically
checked as well.

Who can help me out here ? Thanks in advance.

Coja.
 
If you set your form's "data entry" property to "true" it will let users add
records and view the records they have just added. Once they close and
reopen the form, they will again be able to add, but will not be able to see
previously entered data.

They could get around this by opening the table directly.

If you need to prevent that (and simply hiding the table won't do) then you
will have to give the users NO access to the table. You will have to base
your form on a query that is run with the owner's permission.

Rick B


Dear all,

I am currently learning to work with Access 2003 by
creating a database for a clinical trial. As being the
administrator, I am now trying to give permissions to
certain data entrists. The only permission I want to give
them is to insert by using the forms I have created.
However, according to the book I have (MS Office Access
2003 Bible) this is not possible ?
According to the book, the closest thing is 'Insert data'
for tables and queries. However, when I check that box,
the 'Read data' and 'Read design' are automatically
checked as well.

Who can help me out here ? Thanks in advance.

Coja.
 
Hi Rick,

Thanks for your answer, but I do not fully understand what
you mean. What do you mean by setting my form's "data
entry" property to "true" ? And how do I let a query run
with the owner's permission ?

Coja.
 
In the form's property box you can determine how the form works. There are
options such as how it is sorted, what query or table is used as the record
source, if additions are allowed, if it is a data-entry only forms, etc.

Running a uery with owner's permission means that anyone who runs the query
will be able to access records with the permissions of the query's owner.
If the owner has permission to view records, but the person running the
query does not, they would be able to do so if the "with owner's permission"
option is set (this is done in the query's property box).

You Access Bible should explain all of this in detail if you look for the
terms above in the book's index.


Rick B


Hi Rick,

Thanks for your answer, but I do not fully understand what
you mean. What do you mean by setting my form's "data
entry" property to "true" ? And how do I let a query run
with the owner's permission ?

Coja.
 
Back
Top