view is read only

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

Guest

Hi,
I have problem with this kind of view:
SELECT name, (SELECT 1) as foo FROM table

The result of this view is read only, but only in Access. When I try to open
it in Sql manager, it is possible to change values (in column "name").
Access 2003, SQL 2000

Thanks
 
You will have to replace your view with a stored procedure or a full sql
string.
 
yeah I've been hounding microsoft about opening up on this feature for
a LONG TIME but nobody gave a crap

I think that you might be able to setup an 'instead of trigger'
im not positive though; I just think that is where those fit it

-Aaron
 
Back
Top