April 16th, 2004, 07:49 PM
|
|
Registered User
|
|
Join Date: Apr 2004
Posts: 6
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Help needed with error '80040e57'
I have the following update. I know the error is pertaining to fields shiftbegin and shiftend- I tested update and it worked without these 2 fields. They are updating an access database with field type medium time. I have tried delimiting # and many other attempts and nothing is working. Can anyone give me an example of updating an access database time only (not date and time) field?
rs.Open SQL, my_Conn
SQL = "UPDATE schedule SET shift_dte = '" & Request.Form("dte") & _
"' ,shiftPerson = '"& Request.Form("pname") & _
", Category =" & Request.Form("cathid") &_
" shiftID =" & Request.Form("shiftsel") & _
", shiftBegin = " & Request.Form("sftbeg") &_
", shiftEnd = " & Request.Form("sftend") & _
"' WHERE id = " & Request.Form("ID")
my_conn.Execute SQL
Microsoft JET Database Engine error '80040e57'
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
