Forcing an insert into a View using Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a View with an 'instead of' insertion trigger on it. Consequently i
would like my users to be able to insert records into this View (the trigger
will take care of the insertion into the actual underlying tables).

Unfortunately, on the Access front end, i see that 'new' button is disabled
(despite the fact that the 'allow Insertions' property of the form is set to
'yes').

Any ideas how i can force Access to allow inserts on this View?

Thanks in advance.
 
Oops! silly me - turns out i had forgotten to select a primary key when i
linked to the View. Sorry !
 
Back
Top