[AccessD] Reading FoxPro Tables

Look at version number of msjet40.dl  above Access 2000, right click 
properties of the file in windows explorer, note version number
should be under C:\WINDOWS\system32\msjint40.dll
then toddle over to 
http://support.microsoft.com/default.aspx?scid=/servicedesks/fileversion/default.asp?vartarget=msdn
the MS dll help database
and type in filename  msjet40.dll under "file only"
and check version number that will tell you the version of jet.
They keep changing the method but should be obvious
I have vba code somewhere on Access -L that has slowly been upgraded to 
determine the Jet number
various people have added to the code  look for Reinier Olislagers



Rocky Smolin - Beach Access Software wrote:

> Marty:
>
> Read access would be good enough. How do I check the Jet version?
>
> Regards,
>
> Rocky Smolin
> Beach Access Software
> http://www.e-z-mrp.com
> 858-259-4334
>
> ----- Original Message ----- From: "MartyConnelly" 
> <martyconnelly at shaw.ca>
> To: "Access Developers discussion and problem solving" 
> <accessd at databaseadvisors.com>
> Sent: Saturday, January 01, 2005 1:44 PM
> Subject: Re: [AccessD] Reading FoxPro Tables
>
>
>> Foxpro tables had problems due to political squabbling with Ashton 
>> Tait and Borland back then make sure you are using Jet version 7 or 8
>> If you look through the Jet Version file manifests 4 through 7 there 
>> is some explanation.
>> At one point in the versions changes you only had read access to 
>> linked dbf tables
>>
>> Rocky Smolin - Beach Access Software wrote:
>>
>>> No - it's going to be an app external to a proprietary system from 
>>> which they want to pull data periodically to do some business 
>>> analysis and other reporting.
>>>
>>> Turns out I can connect directly to the .dbf tables if I use Access 
>>> 97. 2000 won't for some reason.
>>>
>>> So I'm past the hump for Monday's meeting with the client.  But I 
>>> think I'll have to get it working in 2000 pretty quickly.
>>>
>>> Rocky
>>>
>>> ----- Original Message ----- From: "Joe Hecht" <jmhla at earthlink.net>
>>> To: "'Access Developers discussion and problem solving'" 
>>> <accessd at databaseadvisors.com>
>>> Sent: Saturday, January 01, 2005 10:28 AM
>>> Subject: RE: [AccessD] Reading FoxPro Tables
>>>
>>>
>>>> Morning Rocky,
>>>>
>>>> Glad I am not the only one working today.
>>>>
>>>> If this is a one time pull  of data you can try going through Excel 
>>>> to get
>>>> the data.
>>>>
>>>> HTH
>>>>
>>>>
>>>> JOE HECHT
>>>> LOS ANGELES CA
>>>> jmhla at earthlink.net
>>>>
>>>> -----Original Message-----
>>>> From: accessd-bounces at databaseadvisors.com
>>>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky 
>>>> Smolin -
>>>> Beach Access Software
>>>> Sent: Saturday, January 01, 2005 8:03 AM
>>>> To: AccessD at databaseadvisors.com
>>>> Subject: [AccessD] Reading FoxPro Tables
>>>>
>>>> Dear List:
>>>>
>>>> I have a requirement to get data from an application written in 
>>>> FoxPro. I
>>>> tried linking the tables to an Access database but apparently I 
>>>> can't do
>>>> that.  I tried to set up the ODBC thingy in the ODBC manager but 
>>>> got stuck
>>>> on the DSN field.  Don't know what to put there.
>>>>
>>>> Can someone get me pointed in the right direction?
>>>>
>>>> Many Thanks In Advance and a Happy New Year To All,
>>>>
>>>> Rocky Smolin
>>>> Beach Access Software
>>>> http://www.e-z-mrp.com
>>>> 858-259-4334
>>>> -- 
>>>> AccessD mailing list
>>>> AccessD at databaseadvisors.com
>>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>>> Website: http://www.databaseadvisors.com
>>>>
>>>>
>>>> -- 
>>>> AccessD mailing list
>>>> AccessD at databaseadvisors.com
>>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>>> Website: http://www.databaseadvisors.com
>>>>
>>>
>>
>> -- 
>> Marty Connelly
>> Victoria, B.C.
>> Canada
>>
>>
>>
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>

-- 
Marty Connelly
Victoria, B.C.
Canada