S
smcgraw
Guest
help!
Im trying to update an MS Access 2000 DB that has a date/time columns unsuccessfully. Ive relied on the data form wizard generated statements and have not modified them.
Scenario#1
With the MS Access data/time columned formated as Short Time I get a concurrency violation error.
Scenario#2
With MS Access data/time columned formated as General Date Error I can write a MM/DD/YY to a general formatted date/time access field, but not the time hh:mm, the hours:minutes are ignored and silently never written w/out any error given.
Sample code attached with a short time database sample.
I can write textbox field data just fine. formating the data in VB.Net doesnt seem to help.
Any suggestions?
Im trying to update an MS Access 2000 DB that has a date/time columns unsuccessfully. Ive relied on the data form wizard generated statements and have not modified them.
Scenario#1
With the MS Access data/time columned formated as Short Time I get a concurrency violation error.
Scenario#2
With MS Access data/time columned formated as General Date Error I can write a MM/DD/YY to a general formatted date/time access field, but not the time hh:mm, the hours:minutes are ignored and silently never written w/out any error given.
Sample code attached with a short time database sample.
I can write textbox field data just fine. formating the data in VB.Net doesnt seem to help.
Any suggestions?