| Susan Denniston 2005-09-19, 8:25 pm |
| Hello,
I am using Access 2003, all up-to-date with the latest Service Packs, (and
thus all relevant drivers, I presume) and am attempting to link to a Paradox
table. It is a free table, with the file extension .db
I need read-only access... no updating to the Paradox table from Access.
I am using the built-in driver -- no need for ODBC for Paradox, as I
understand it.
The table is from FoxPro Ver. 7 (possibly Ver. 8--am trying to get this
confimed.).
Access believes it successfully links to the table, and it shows up as a
linked Paradox table. But the bizarre result is in the data:
Column names are bad: "Column0" "Column1" etc. The very first column is
named 'noname.' If looking at the table in Design view, ALL columns are
named 'noname."!
Worst of all: every column in every row is exactly the same - equal to the
value from the very first column. This value is the same for all rows, so
the entire database is filled with exactly one text value!
Anybody ever see such a thing?
Many thanks,
Susan
|