ADP Form Basd on View Inserting into Table Anyway

  • Thread starter Thread starter Dean
  • Start date Start date
D

Dean

I Have an Access ADP file that has a form based on a view. My view is
updatable, and I avoid giving users permissions to base tables as the view
contains permissions logic.

When I try to insert into the form (or the view from Access), Access
converts the insert statement into an sp_executesql command. Great for
performance, but the problem is that it reverts back to referencing the table
name. In other words, using the view appears to be useless.

The UniqueTable property seems relevant, but the view never appears in the
list.

Any one have a suggestion? Thanks in advance...
 
FYI I figured this one out guys. Acess cannot determine the PrimaryKey unless
the VIEW has the WITH VIEW_METADATA; I should have known this!!
 
Back
Top