Hi All
I'm pulling my hair out. I'm SQL Dev with limited Access Dev. I have an Access Db with a SQL Backend that has been given to me.
In the Access Db, the previous Dev created linked tables to views in the SQL and forms with subforms referencing the view.
I can see why he did a view which combines a static informational table with a manual entry table that needs to link to a record in the information table but my problem is, it works fine if you only join 2 tables since it's a view.
I NEED it to join 3 in the view. When I update the view in SQL, relink the table in Access and try to enter or change a record, I get :
"Update or insert of view or function 'dbo.view_..blah blah' failed because it contains a derived or constant field".
Is there a workaround or trick for this? I was thinking I could just put an update statement for SQL behind each of the fields that needs to get chnaged but I don't know what event I put that in.
Argghh..I've been trying to figure this out for 2 days...
Anyone have to work with this before?
Thanks!
I'm pulling my hair out. I'm SQL Dev with limited Access Dev. I have an Access Db with a SQL Backend that has been given to me.
In the Access Db, the previous Dev created linked tables to views in the SQL and forms with subforms referencing the view.
I can see why he did a view which combines a static informational table with a manual entry table that needs to link to a record in the information table but my problem is, it works fine if you only join 2 tables since it's a view.
I NEED it to join 3 in the view. When I update the view in SQL, relink the table in Access and try to enter or change a record, I get :
"Update or insert of view or function 'dbo.view_..blah blah' failed because it contains a derived or constant field".
Is there a workaround or trick for this? I was thinking I could just put an update statement for SQL behind each of the fields that needs to get chnaged but I don't know what event I put that in.
Argghh..I've been trying to figure this out for 2 days...
Anyone have to work with this before?
Thanks!