>Cetin,
>
>Here's the Sql query from teh view....what am I missing. The error message is still coming up and not saving my updates...
>
>SELECT *;
> FROM patsdata!personnel;
> WHERE Personnel.pk_pers_id <> 0;
> ORDER BY Personnel.l_name

You're selecting all fields. Check wheretype. You might need to increase complexity level with sys(3055).
Cetin