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. -- JP
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 "McMogul" wrote: > 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. > -- > JP
