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

[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?

 

[Sylvain Lafontaine]

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?

 

[Guest]

So I'll have to create an unbound form and use ADO? How will that
effect the sub-forms? Are there alternatives?

 

[dbahooker]

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