A form containing a field from a limited access table

[Lynn atkinson]

I have a form based on a query containing 2 tables. A
request has been made to add a field (as display only) to
this form but the field comes from a table which has
restricted access to it. Is it possible to create a form
for general use, but displaying a field from a restricted
table?

 

[TC]

There are several ways you could do this. Since the fatabase is already
secured, perhaps the easiest way, is this.

Create a so-called "Run With Owner Permission" (RWOP) query:

SELECT TheField
FROM TheTable
WITH OWNERACCESS OPTION

Make sure that query is >owned< by a user who >does< have read-access to the
table in question.

Now ensure that everyone who can run the form, has read-access to the RWOP
query.

Now, even though the users who can run the form, do not have permission to
read the table >directly<, they will be able to use the RWOP query, to see
the values of that single field in the restricted table.

Then add the RWOP query to the query which drives the form.

HTH,
TC