Groups | Blog | Home
all groups > dotnet datatools > january 2006 >

dotnet datatools : Writing to Access Database Problem


McMogul
1/3/2006 9:12:05 AM
Hi,

I am updating an Access Database (4.0 all service packs up to date) with a
vb.net web application. The data adapter and update commands are all formed
with the wizard. When I update a field that is defined as 'Date/Time' with a
'General' format in the database with the system variable 'Now', vb drops the
time component and only updates the database with the date. This causes
concurrency exceptions also. When I prime the database with a date without
the time, all is well. I noticed that the data adapter defined the column as
'Date'. Any help would be appreciated. Thanks.
--
McMogul
1/3/2006 12:06:05 PM
I have more information to add: when I change the generrated code from
'ctype(.....,dbdate)' to 'ctype(.....,date)' it works like a champ. Must be a
Microsoft bug.
--
JP


[quoted text, click to view]
AddThis Social Bookmark Button