Access 2K3, SQL Server 2K5, "Instead of" Trigger Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
So I'll have to create an unbound form and use ADO? How will that
effect the sub-forms? Are there alternatives?
 
why dont you just use a simple integer as a PK

and then you can take your extra special PK and shove it wherever you
want to


-Aaron
 
Back
Top