want to link to dos foxpro db files. how ?

  • Thread starter Thread starter Kirk
  • Start date Start date
K

Kirk

I need to link to an old dos foxpro database.

Did it in Win 98 Access 2000 by installing mdac file. Now
running XP and Access 2002. Do i need an mdac that
supports foxpro ? Or do i do it another way ?
Foxpro dbf files on network drive H.

Any help would be appreciated.

Thanks,
Kirk
 
Hi Kirk,

Do you not have file type "DBase IV" in your list of file types that Access
can link/import directly?
 
-----Original Message-----
I need to link to an old dos foxpro database.

Did it in Win 98 Access 2000 by installing mdac file. Now
running XP and Access 2002. Do i need an mdac that
supports foxpro ? Or do i do it another way ?
Foxpro dbf files on network drive H.

Any help would be appreciated.

Thanks,
Kirk.
Click to expand...

Kirk

I have a similar problem, I managed to link the DBASE.DBF
file from our server by telling Access that the INDEX file
is of type CDX, I think Access looks for NDX or MDX by
default. To list them when asked for index TYPE *.CDX
then choose your file, The only problem with this is that
you can see the table in the tables window but will not be
able to open it to look at the data ( this is my problem).
I know that the memo file for old dos FOXPRO is of type
FPT but Access is looking for a type MDX do you know how
to tell Access to look for the FPT file?
 
Hi.

I do have this, but maybe i'm not doing it right. FYI, i
had this working in Access 2000. My mdb file is linked to
our old foxpro program tables. I only pull info out of
the tables. I do not update them. When i converted my mdb
to 2002, i lost my links. They show in the mdb file, but
the links don't work.

When i try to link them over again as dbase tables, it
won't link a table with no index. If i try to refresh the
existing links in Linked Table Mgr, i think i don't have
the right data source type. It tells me i can't use odbc
to link the tables.

I remember having to download an MDAC to get the link to
work in Access 2000.

Thanks,
Kirk
 
Back
Top