I created a query with an odbcdataadapter to a linked table in a Microsoft
Access Database.
When I view the data, everything appears fine except one field is being
displayed as a date where it should be a time. I double checked the field
definitions in Access and everything looks good.
I changed the schema in the dataset from Datetime to time but it still
doesn't work.

Any help would be appreciated.
I would like to point out I have only recently upgraded to vb.net from
Visual Basic 4.0 so this new data access stuff is really new (and confusing)
to me.
--
Mark Escandon
Production/Systems Manager
Fybon Industries

Hi,

How are you displaying the data?

Ken
----------------
"Mark Escandon" <(E-Mail Removed)> wrote in message
news:A6937C2C-0FAE-4E62-B502-(E-Mail Removed)...
I created a query with an odbcdataadapter to a linked table in a Microsoft
Access Database.
When I view the data, everything appears fine except one field is being
displayed as a date where it should be a time. I double checked the field
definitions in Access and everything looks good.
I changed the schema in the dataset from Datetime to time but it still
doesn't work.

Any help would be appreciated.
I would like to point out I have only recently upgraded to vb.net from
Visual Basic 4.0 so this new data access stuff is really new (and confusing)
to me.
--
Mark Escandon
Production/Systems Manager
Fybon Industries

I am using the datagrid control. But I've also previewed the data in design
mode (via the data adapter property) and it looks the same.

Instead of saying 11:59:34 PM, it says 12/30/1899.

"Ken Tucker [MVP]" wrote:

> Hi,
>
> How are you displaying the data?
>
> Ken
> ----------------
> "Mark Escandon" <(E-Mail Removed)> wrote in message
> news:A6937C2C-0FAE-4E62-B502-(E-Mail Removed)...
> I created a query with an odbcdataadapter to a linked table in a Microsoft
> Access Database.
> When I view the data, everything appears fine except one field is being
> displayed as a date where it should be a time. I double checked the field
> definitions in Access and everything looks good.
> I changed the schema in the dataset from Datetime to time but it still
> doesn't work.
>
> Any help would be appreciated.
> I would like to point out I have only recently upgraded to vb.net from
> Visual Basic 4.0 so this new data access stuff is really new (and confusing)
> to me.
> --
> Mark Escandon
> Production/Systems Manager
> Fybon Industries
>
>
>