Access 2003 and DBF

[pekuiper]

I have access 2003 and currently linked to an old Fox Pro dbf file. I am working to bringing the companies old dos programs up to date with Access. This is what I am dealing with: In Access I can read everything from the Fox Pro DBF file, I can add data in the Fox Pro DBF and see the new data in Access with out delay, I can add data in Access and see it in the Access linked table. Question: Does any one know why I can't see the new data in the Fox Pro dbf file.

 

[KenHigg]

Unicode?

Do you have Access 97 you can tinker around with - I think it was pre unicode


ken

 

[pekuiper]

No only 2003

 

[KenHigg]

Are you linking through odbc?

 

[pekuiper]

Sorry not sure what odbc is - I linked by file import.

 

[pekuiper]

I see that the dBASE Files are allready in the ODBC Data Source Administrator

 

[KenHigg]

Instead of a direct link like you have, odbc is kind of another layer between the application and the datasource taht provides a sort of uniformity between data sources and the apps. I thought FoxPro might have a odbc driver that would iron out your issue. For example you would run the odbc administrator application and create a new odbc 'foxpro' datasource. The odbc driver would 'fix' the data and then you would link to it through the newly set up odbc datasource...

Just a wild guess on my part - You may want to ggogle odbc stuff an read up a bit...


ken