INSERT this.... expected 1

[colzboppo]

Im using Access2000
UltraDev...Sorry
And it works fine inserting elsewhere...
This meesage has come up before for, me. It is when I am Inserting a new record, and there is a many-to-one relational numeric field in there. It pulls up the Column Header type mismatch error, yet my headers are all the same DB, and ASP!? Im using UltraDev which doesn't help. Any suggestions? Normally I'd remove the relationship, are these relationships built in access necessary? Or is using the INNER JOIN command creating a relationsship...Grr..

 

[colzboppo]

The error I get exactly is:

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

/

http://wwwroot/employers/submit.asp,

line 90

 

[colzboppo]

Now I get
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

/

http://wwwroot/employers/submit.asp,

line 91
Instead....
Great....

 

[nickjar2]

check this out:

http://support.microsoft.com/support/kb/articles/Q207/5/86.ASP?LN=EN-GB&SD=gn&FR=0

Nick