DateTime no Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the OleDbAdapter to access a simple ACCESS database. One of the
fields is a date/time field. When I insert a record from my NET app, the time
portion of the field is missing in the database. I tried changing the data
adapter to use a DBTimeStamp instead of a DBDate in the insert command and I
get excpetions thrown on the insert "type mismatch in criteria expression"

ideas??? I'm going nuts
thanks
 
¤ I am using the OleDbAdapter to access a simple ACCESS database. One of the
¤ fields is a date/time field. When I insert a record from my NET app, the time
¤ portion of the field is missing in the database. I tried changing the data
¤ adapter to use a DBTimeStamp instead of a DBDate in the insert command and I
¤ get excpetions thrown on the insert "type mismatch in criteria expression"

Use Date instead of DBDate for a Microsoft Access database.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top