Hello,
I have an Access Database 2007 that is linked to our SQL Server 2008.
In my MSA I have a Form that has recordsource which is view. User can update his userid so far without any issues. Now I have selected
a new column in the view which already exists in one of the main table. since then I started getting this error when i try to update userid using
rst.update command. As soon as I remove the column from the view and relink SQL server database again, it works just fine.
Please help.
I have an Access Database 2007 that is linked to our SQL Server 2008.
In my MSA I have a Form that has recordsource which is view. User can update his userid so far without any issues. Now I have selected
a new column in the view which already exists in one of the main table. since then I started getting this error when i try to update userid using
rst.update command. As soon as I remove the column from the view and relink SQL server database again, it works just fine.
Please help.