Posted by Dia on 11/30/06 11:39

Ed Murphy wrote:
> Dia wrote:
>
> > I struggle to get this going i would like to insert data into 2 tmp
> > tables in a view.
> > If i run the code on it's own it works perfectly until i want to create
> > a view it complains about the INSERT
>
> You need a stored procedure, not a view.

I need a vew to link into a query in Access for a report, so it's not
possible to do this in a view???

If not then i'll have to work my way around running a stored procedure
BUT would really settle for a view

[Back to original message]