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

On Thu, 20 Jan 2005 11:27:03 -0800, cje <(E-Mail Removed)> wrote:

¤ 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 Removed)
Microsoft MVP (Visual Basic)