[AccessD] Reading FoxPro Tables

oops that should be
C:\WINDOWS\system32\msjet40.dll

MartyConnelly wrote:

> 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