Hi folks,
I have a form in datasheet view which is linked to a view on SQL Server 2005.
When i open the linked view directly I can add/update records as usual without error. When I try to add a record through the datasheet form I get error #4405
"View or function 'dbo.Q_PSR_P6_FND' is not updatable because the modification affects multiple base tables."
Don't know why it only shows this error when adding records through a form.
I'm using Access 2010 FE and SQL 2005 BE.
Any help much appreciated.
I have a form in datasheet view which is linked to a view on SQL Server 2005.
When i open the linked view directly I can add/update records as usual without error. When I try to add a record through the datasheet form I get error #4405
"View or function 'dbo.Q_PSR_P6_FND' is not updatable because the modification affects multiple base tables."
Don't know why it only shows this error when adding records through a form.
I'm using Access 2010 FE and SQL 2005 BE.
Any help much appreciated.
