Access/Visual FoxPro Problem

[TAMER]

Hi all,
After I successfully installed the ODBC driver to link
some Visual FoxPro Tables to my Access database, I've
noticed the following behavior on the linked tables:-

* In creating queries, some fields from the linked tables
have extra spaces, the way if I combine the [Last_Name]
& " " & [First_Name], it gives me something like this:
Johny John (note the unecessary space)

* All the Null Dates don't return Null values, instead
they return 12:00:00 or 12/31/1899 !!

* TOTALS Queries to get the first or the last value don't
return accurate information when the field used to perform
the calculations is coming from a linked tables.

Am I asking this in the right place? If not, where can I
get answers to these issues? Is there a Visual FoxPro
community group?

Thanks for your help.

 

[Cindy Winegarden]

In [email protected],

After I successfully installed the ODBC driver to link
some Visual FoxPro Tables to my Access database, I've
noticed the following behavior on the linked tables:- .......
Am I asking this in the right place? If not, where can I
get answers to these issues? Is there a Visual FoxPro
community group?

Hi,
I see you've found the Visual FoxPro groups and you've gotten some help
there.