UniqueTable -> View

[Peter Ramsebner]

Hi all,

is it possible to use a view for the UniqueTable Property?

I don't want that the users can read the hole table, so the form uses a
stored procedure with parameters as recordsource.
But the form should be updateable, so i need to put the UniqueTable
property. But i can't use the underlying table because the user have no
permissions on it.
Now i have created a view which returns only a view records which i want to
use for the UniqueTable property. The view returns all columns of the
underlying table and uses only this table (no joins).

-> The problem is that access don't accept the viewname in the property.

Is there a solution for my problem?

thanks Peter

 

[Daran Johnson]

Peter,

If you are binding the table to the form and want it to be updateable then
you will have to manage the permissions at the table. You can use stored
procedures or embedded SQL (not advisable) and set the returned recordset
values to the text boxes, combo boxes, etc. and use another stored procedure
for updates. It is a far more involved process. The benefits are that you
have greater control over the values passed and greater security.

-Daran

 

[Peter Ramsebner]

Hi Daran,

you are speaking of unbound forms.
I can't use an unbound form because i want to display my form in listform.

Peter