Using MS Access with Foxpro tables

When I am in MS Access and attempt to link to a Foxpro table in dBASE IV
format, even tough I navigate to the file with Access, when I click on it I
get the error message
The Microsoft Jet database engine could not find the object 'xxx.dbf'. Make
sure the object exists and that you spell its name and path...

Any ideas?

Thanks in advance for your help
Fred

Dan
Wed Oct 12 10:36:30 CDT 2005

Foxpro files are not dBase IV format. Go to msdn.microsoft.com/vfoxpro and
download the Foxpro ODBC driver.

Dan


Fredrated wrote:
> When I am in MS Access and attempt to link to a Foxpro table in dBASE
> IV format, even tough I navigate to the file with Access, when I
> click on it I get the error message
> The Microsoft Jet database engine could not find the object
> 'xxx.dbf'. Make sure the object exists and that you spell its name
> and path...
>
> Any ideas?
>
> Thanks in advance for your help
> Fred

Fredrated
Wed Oct 12 12:22:04 CDT 2005

Dan

Thanks for your reply, it indicates I was perhaps not specific enough in my
message.
The people I am working with are using an application called "Arc GIS" for
mapping. They tell me that Arc GIS will only read dBASE IV table files, and
they want me to do some programming to process the files they are using.
They are using Foxpro 5 to edit the files. Since I haven't used Foxpro much
since 2.0 and am now very conversant in MS Access, I am hoping to do the
programming to process the files, inclucing saving the results, in MS Access.
They tell me the .dbf files they have provided are in dBASE IV format.

I am looking through the ODBC drivers to see if there is something there I
can use

Fred

"Dan Freeman" wrote:

> Foxpro files are not dBase IV format. Go to msdn.microsoft.com/vfoxpro and
> download the Foxpro ODBC driver.
>
> Dan
>
>
> Fredrated wrote:
> > When I am in MS Access and attempt to link to a Foxpro table in dBASE
> > IV format, even tough I navigate to the file with Access, when I
> > click on it I get the error message
> > The Microsoft Jet database engine could not find the object
> > 'xxx.dbf'. Make sure the object exists and that you spell its name
> > and path...
> >
> > Any ideas?
> >
> > Thanks in advance for your help
> > Fred
>
>
>

Anders
Thu Oct 13 00:49:13 CDT 2005

Use VFP to load Access through Access ODBC or through XML. Let Access output
to some other format than DBase, like csv or XML, and back into VFP to turn
it into older type DBF files that Arc GIS can read. If the people you're
working with are using Foxpro 5 then DBaseIV format is not required. It's
Access that only understands DBase.
Access can read VFP data directly through VFPODBC or VFPOLDB or output to
XML which later versions of VFP can read.
-Anders


"Fredrated" <Fredrated@discussions.microsoft.com> skrev i meddelandet
news:F86974BD-0D25-429B-82B5-3A65CD95353E@microsoft.com...
> Dan
>
> Thanks for your reply, it indicates I was perhaps not specific enough in
> my
> message.
> The people I am working with are using an application called "Arc GIS" for
> mapping. They tell me that Arc GIS will only read dBASE IV table files,
> and
> they want me to do some programming to process the files they are using.
> They are using Foxpro 5 to edit the files. Since I haven't used Foxpro
> much
> since 2.0 and am now very conversant in MS Access, I am hoping to do the
> programming to process the files, inclucing saving the results, in MS
> Access.
> They tell me the .dbf files they have provided are in dBASE IV format.
>
> I am looking through the ODBC drivers to see if there is something there I
> can use
>
> Fred
>
> "Dan Freeman" wrote:
>
>> Foxpro files are not dBase IV format. Go to msdn.microsoft.com/vfoxpro
>> and
>> download the Foxpro ODBC driver.
>>
>> Dan
>>
>>
>> Fredrated wrote:
>> > When I am in MS Access and attempt to link to a Foxpro table in dBASE
>> > IV format, even tough I navigate to the file with Access, when I
>> > click on it I get the error message
>> > The Microsoft Jet database engine could not find the object
>> > 'xxx.dbf'. Make sure the object exists and that you spell its name
>> > and path...
>> >
>> > Any ideas?
>> >
>> > Thanks in advance for your help
>> > Fred
>>
>>
>>

bbettsack
Tue Oct 18 10:37:03 CDT 2005

I just finished writting an APP (VFP9.0) that interfaces with the ARC GIS
system (ARC MAP). It involved using a utility program called 'Edit Common
Attributes' in the ARC MAP module to read certain data from 'Access' file
that was created from data in a VFP Database. If you send me more info I may
be able to help you.
--
Lost in Tampa


"Fredrated" wrote:

> When I am in MS Access and attempt to link to a Foxpro table in dBASE IV
> format, even tough I navigate to the file with Access, when I click on it I
> get the error message
> The Microsoft Jet database engine could not find the object 'xxx.dbf'. Make
> sure the object exists and that you spell its name and path...
>
> Any ideas?
>
> Thanks in advance for your help
> Fred
>

Fredrated
Thu Oct 20 17:11:06 CDT 2005

I am not sure what to tell you beyond how I have described the problem.
Are you suggesting that I can import 'foxpro' (dBASE IV) data, process it in
access, and then use 'Edit Common Attributes' in ARC GIS to read the access
data?
The people I am working with don't think ARC GIS is capable of working with
anything other than dBASE IV files, but thay may be wrong.

Thanks
Fred

"bbettsack" wrote:

> I just finished writting an APP (VFP9.0) that interfaces with the ARC GIS
> system (ARC MAP). It involved using a utility program called 'Edit Common
> Attributes' in the ARC MAP module to read certain data from 'Access' file
> that was created from data in a VFP Database. If you send me more info I may
> be able to help you.
> --
> Lost in Tampa
>
>
> "Fredrated" wrote:
>
> > When I am in MS Access and attempt to link to a Foxpro table in dBASE IV
> > format, even tough I navigate to the file with Access, when I click on it I
> > get the error message
> > The Microsoft Jet database engine could not find the object 'xxx.dbf'. Make
> > sure the object exists and that you spell its name and path...
> >
> > Any ideas?
> >
> > Thanks in advance for your help
> > Fred
> >

bbettsack
Wed Oct 26 06:59:04 CDT 2005

The app I wrote creates a Dbase file that is imported to an Access Database
which is used by the ARC MAP program as input data. It contains many fields
such as Atlas Page #, Section, Township, Range and Description. ARC MAP only
reads the Access Files not the Dbase Files. The 'Edit Common Attributes'
program is an add-on module to ARC MAP and is turned-on when you start
editing a .lyr file.
--
Lost in Tampa


"Fredrated" wrote:

> I am not sure what to tell you beyond how I have described the problem.
> Are you suggesting that I can import 'foxpro' (dBASE IV) data, process it in
> access, and then use 'Edit Common Attributes' in ARC GIS to read the access
> data?
> The people I am working with don't think ARC GIS is capable of working with
> anything other than dBASE IV files, but thay may be wrong.
>
> Thanks
> Fred
>
> "bbettsack" wrote:
>
> > I just finished writting an APP (VFP9.0) that interfaces with the ARC GIS
> > system (ARC MAP). It involved using a utility program called 'Edit Common
> > Attributes' in the ARC MAP module to read certain data from 'Access' file
> > that was created from data in a VFP Database. If you send me more info I may
> > be able to help you.
> > --
> > Lost in Tampa
> >
> >
> > "Fredrated" wrote:
> >
> > > When I am in MS Access and attempt to link to a Foxpro table in dBASE IV
> > > format, even tough I navigate to the file with Access, when I click on it I
> > > get the error message
> > > The Microsoft Jet database engine could not find the object 'xxx.dbf'. Make
> > > sure the object exists and that you spell its name and path...
> > >
> > > Any ideas?
> > >
> > > Thanks in advance for your help
> > > Fred
> > >

Andrew
Thu Oct 27 03:05:22 CDT 2005

"Fredrated" <Fredrated@discussions.microsoft.com> wrote in message
news:C0F9AA76-9221-4AAF-8A77-E9ABFD6BB648@microsoft.com...
> When I am in MS Access and attempt to link to a Foxpro table in dBASE IV
> format, even tough I navigate to the file with Access, when I click on it
> I
> get the error message
> The Microsoft Jet database engine could not find the object 'xxx.dbf'.
> Make
> sure the object exists and that you spell its name and path...
>
> Any ideas?
>
> Thanks in advance for your help
> Fred

Are the dbf files on a network location or the local machine?

If they work when stored locally but not on a network there may be some
service running as LOCAL SYSTEM (ie has no network access) which is trying
to open it and the real error is "access denied."

You can get more information on why / what is happening by running filemon
from http://www.sysinternals.com/Utilities/Filemon.html and setting some
filters (eg on the filename) and seeing what the real error is.

--
HTH
Andrew Howell

Demetrios
Thu Oct 27 08:09:31 CDT 2005

Hi,
As a first idea, you can convert the tables to dbase III tables.
unless you have them in a database container.

Use Table1
Copy to table_1 fox2x (<-- dbase III compatible table)

dbase III files are accesible and updatable from ArcGis and from VFP

Demetrios, Greece

Fredrated wrote:
> Dan
>
> Thanks for your reply, it indicates I was perhaps not specific enough in my
> message.
> The people I am working with are using an application called "Arc GIS" for
> mapping. They tell me that Arc GIS will only read dBASE IV table files, and
> they want me to do some programming to process the files they are using.
> They are using Foxpro 5 to edit the files. Since I haven't used Foxpro much
> since 2.0 and am now very conversant in MS Access, I am hoping to do the
> programming to process the files, inclucing saving the results, in MS Access.
> They tell me the .dbf files they have provided are in dBASE IV format.
>
> I am looking through the ODBC drivers to see if there is something there I
> can use
>
> Fred
>
> "Dan Freeman" wrote:
>
>
>> Foxpro files are not dBase IV format. Go to msdn.microsoft.com/vfoxpro and
>> download the Foxpro ODBC driver.
>>
>> Dan
>>
>>
>> Fredrated wrote:
>>
>>> When I am in MS Access and attempt to link to a Foxpro table in dBASE
>>> IV format, even tough I navigate to the file with Access, when I
>>> click on it I get the error message
>>> The Microsoft Jet database engine could not find the object
>>> 'xxx.dbf'. Make sure the object exists and that you spell its name
>>> and path...
>>>
>>> Any ideas?
>>>
>>> Thanks in advance for your help
>>> Fred
>>>
>>
>>

Fredrated
Fri Oct 28 10:21:03 CDT 2005

The solution was to change the long filename to a short filename!
My guess is that since dBASE IV was originally used in a DOS environment,
the code that attempts to open a dBASE IV file has legacy code that only
recognizes file names with 8 or fewer characters.

What a drag, but at lease I can now proceed and solve the original
programming problem in Access.

My thanks to everyone that responded.
Fred

"Fredrated" wrote:

> When I am in MS Access and attempt to link to a Foxpro table in dBASE IV
> format, even tough I navigate to the file with Access, when I click on it I
> get the error message
> The Microsoft Jet database engine could not find the object 'xxx.dbf'. Make
> sure the object exists and that you spell its name and path...
>
> Any ideas?
>
> Thanks in advance for your help
> Fred
>