Problem Updating MDB Database
Posted on 2007-07-19
I'm having issues inserting information into a database (MDB). I believe everything in the database is set up. The field in question is a Date/Time format. Here's my code inserting into the database.
Set MyRs = Myconn.Execute("UPDATE all_users Set Name= '" & xName & "', Age= '" & Age & "', Sex= '" & _
Sex & "' , City= '" & IIf(Len(city), city, Null) & "', State= '" & IIf(Len(state), state, Null) & _
"', Country= '" & Country & "' , Music='" & IIf(Len(xMusic), xMusic, Null) & "', Last Login='" & Last_Login & "' Where ID ='" & List1.Text & "'")
To get Last_Login, I do this:
Last_Login = CDate(Split(strTemp, ":")(1))
Last_Login should be the correct format, is something else wrong?