Forcing an insert into a View using Access

J

Jeff

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.
 
J

Jeff

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top