FoxPro Help and Support - Linking foxpro to Access

Author

Linking foxpro to Access

Jaimi

2005-07-18, 9:24 am

I am trying to link a foxpro table to access.
I can link it, but the blank date fields are showing up as time 12:00:00AM
I want to remove this. When I choose in Access to short date it changes the
time to
a date of 12/30/1899

Thanks

Cindy Winegarden

2005-07-18, 1:24 pm

Hi Jaimi,

Access doesn't have the concept of an empty date so you're pretty much out
of luck. As a work-around you could add a field to your Fox table that holds
a character representation of the date, but you'd have to make sure to keep
it updated when the source field changes.

--
Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden

"Jaimi" <Jaimi@discussions.microsoft.com> wrote in message
news:AC4C62BC-AD95-4341-88D4- 34176F752DF5@microso
ft.com...
>I am trying to link a foxpro table to access.
> I can link it, but the blank date fields are showing up as time 12:00:00AM
> I want to remove this. When I choose in Access to short date it changes
> the
> time to
> a date of 12/30/1899
>
> Thanks
>

Sponsored Links