Access 2K3, SQL Server 2K5, "Instead of" Trigger Problem imani_technology_spam[ at ]yahoo.com 22.09.2006 00:00:18 The front end is an MS Access 2003 ADP. The back end is an MS SQL Server 2005 database. I have a form that is based on a view. The view is based on a couple of tables. The primary table in the view has an "Instead Of" trigger. The trigger automatically generates a value for the primary key of the primary table if the new row has a null value for the primary key field. As a result, when I try to add a row in the form, I get the following error: "Invalid input parameter values. Check the status values for details." Could someone please explain to this weary soul what is going on?

Re: Access 2K3, SQL Server 2K5, "Instead of" Trigger Problem "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> 22.09.2006 18:47:54 It's possible that you are well over the possibilities (or limitations) of ADP bound forms. Why not add a « Create new record » button which will create the new record on the SQL-Server using the standard ADO objects and then requery the form to display it? -- Sylvain Lafontaine, ing. MVP - Technologies Virtual-PC E-mail: http://cerbermail.com/?QugbLEWINF <imani_technology_spam[ at ]yahoo.com> wrote in message news:1158883218.757089.261540[ at ]i3g2000cwc.googlegroups.com... [Quoted Text] > The front end is an MS Access 2003 ADP. The back end is an MS SQL > Server 2005 database. I have a form that is based on a view. The view > is based on a couple of tables. The primary table in the view has an > "Instead Of" trigger. The trigger automatically generates a value for > the primary key of the primary table if the new row has a null value > for the primary key field. As a result, when I try to add a row in the > form, I get the following error: > > "Invalid input parameter values. Check the status values for details." > > Could someone please explain to this weary soul what is going on? >

Re: Access 2K3, SQL Server 2K5, "Instead of" Trigger Problem imani_technology_spam[ at ]yahoo.com 22.09.2006 20:57:04 So I'll have to create an unbound form and use ADO? How will that effect the sub-forms? Are there alternatives? Sylvain Lafontaine (fill the blanks, no spam please) wrote: [Quoted Text] > It's possible that you are well over the possibilities (or limitations) of > ADP bound forms. > > Why not add a « Create new record » button which will create the new record > on the SQL-Server using the standard ADO objects and then requery the form > to display it? > > -- > Sylvain Lafontaine, ing. > MVP - Technologies Virtual-PC > E-mail: http://cerbermail.com/?QugbLEWINF > > > <imani_technology_spam[ at ]yahoo.com> wrote in message > news:1158883218.757089.261540[ at ]i3g2000cwc.googlegroups.com... > > The front end is an MS Access 2003 ADP. The back end is an MS SQL > > Server 2005 database. I have a form that is based on a view. The view > > is based on a couple of tables. The primary table in the view has an > > "Instead Of" trigger. The trigger automatically generates a value for > > the primary key of the primary table if the new row has a null value > > for the primary key field. As a result, when I try to add a row in the > > form, I get the following error: > > > > "Invalid input parameter values. Check the status values for details." > > > > Could someone please explain to this weary soul what is going on? > >