M
Microsoft
Can someone tell me why I might be unable to insert into a view in Access
2000 against SQL Server 7? I have created a view for a subform with an
order by clause so I can get the records created the way I want it (this is
to get around the bug Microsoft acknowledges with inserting in subforms
using SQL as the datasource for the form). If I look at the view in
Enterprise manager, I see that I have a new record at the bottom of the
resultset. However, if I open this view in Access, I cannot insert any
records. Also, the subform won't let me go to the new record. In case
anybody asks, I am logging into the SQL Server with the same account through
both tools, so it's not a permission problem.
Thanks,
Lance
2000 against SQL Server 7? I have created a view for a subform with an
order by clause so I can get the records created the way I want it (this is
to get around the bug Microsoft acknowledges with inserting in subforms
using SQL as the datasource for the form). If I look at the view in
Enterprise manager, I see that I have a new record at the bottom of the
resultset. However, if I open this view in Access, I cannot insert any
records. Also, the subform won't let me go to the new record. In case
anybody asks, I am logging into the SQL Server with the same account through
both tools, so it's not a permission problem.
Thanks,
Lance