By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,776 Members | 1,302 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,776 IT Pros & Developers. It's quick & easy.

ASP.NET VB script insert record. error '80004005'

P: 5
Hi

I am inserting some records into my access database using asp.net vb script.

The problem is that "Username" is set to "Not Null" in my database and so i get the following message returned.

Microsoft JET Database Engine error '80004005'

The field 'CustomerOrder.Username' cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.

/james/placeorder.asp, line 135

However, i have tested it and i am sure that i have a value in the field for "Username". I have done a query to retrieve this.

Heres the code:

<input name="Username" type="hidden" id="Username" value="<%=(Recordset2.Fields.Item("Username").Valu e)%>">

So if the value is present, why isnt it going into the table?!

Any help greatly appreciated.

thank you
Apr 22 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.