ODBC connection to Foxpro from Access 2007
doc
Basically this is the situation.
I have a database which was developed using Visual FoxPro 6.0 (released as part
of Visual Studio 6 in 1998). The database consists of a number of separate dbf
files in as single directory.
What I would like to do is to query this data. I have Access 2007 installed on
Windows 7 64 bit (it is a brand new install on a clean/new hard disk There is
4GB of RAM and 100GB of free HDD space). My plan was to set up an ODBC
connection to the foxpro Data and work from there. I used the 32bit ODBC admin
tool to set up the connection, and then tried to link the tables in access 2007
using the external data/ODBC facility.
That worked ok, in so far as it displayed the list of tables, prompted me to
identify primary keys etc
The problem I'm having seems to be some sort of display issue but I'm unsure
where this is originating - is it Access, Windows 7, 32bit/64 bit, ODBC, foxpro,
file size (one of the dbf files is 500MB), memory management etc.
What happens is when I browse the contents of the main table I'm interested in
(the 500MB one above), many of the rows appear to contain duplicate data - i.e.
several fields in different records show the same content. However, I know the
data is ok for two reasons - firstly, I'm linking, not importing - so the source
data is left instact (and I can see it through the original Foxpro front end),
and secondly, I can run certain types of JOIN query which show the data as I
would expect.
It is all very strange!
Any suggestions as to what is causing this, or how I might solve it?