Update foxpro tables (1 Viewer)

[scooper]

Hello everyone!

I have a problem with a program that I am working on. I created a program in Access 2000 that isl ink to a foxpro data. all of the functinalities in access 2000 works fine accept one thing.

I cannot update the link table from access 2000 to foxpro, I created a update query and that will not work either, I also try saving the table as a dbf table from ms Access 2000 and replace it with the one in foxpro and the foxpro application would not work properly.

Is there something that I am doing wrong or Access 2000 cannot update foxpro data, it is some old vision of foxpro, 3.0 and i want to be able to both work in update the same tables from foxpro and Access 2000.

My office is about to hire some foxpro expert and i want to know if this is possiable befor they do. Please Help!!!

 

[Pat Hartman]

I haven't linked to FoxPro tables specifically, but for linked ODBC tables to be updateable, they MUST contain a unique primary key. I think this is stored as a separate table with dBase and might also be with FoxPro. Another thing to look into is you might actually need FoxPro to be installed on your PC so that the ODBC driver can use it to update the FoxPro table. Try searching the Microsoft Knowledge base for more info.

 

[scooper]

Hi Pat,

Thanks for your suggestion. i created the link between the FoxPro table and access 2000 using Visual Foxpro ODBC driver. There are restraction on the FoxPro table when ever I view the link table in design view from access 2000. Restraction like field require. Due to this restraction, whenever I update with blenk field give me error.

are you saying I should install foxpro on the computer, open the dbf files and change the restraction? another question, if I use visual foxpro vision 6 which I have to change restraction on foxpro 2.6 table (dbase III table), wouldn't I have problem? or is this easy to deal with in access 97?

 

[Pat Hartman]

Your original question was very general and you omitted some important information relating to your precise error. If the FoxPro table has required fields defined, you MUST supply values for them if you expect to be able to insert new rows. You cannot change the design properties of ANY linked table, not just FoxPro, by using the Access GUI. If you want to change the fields from required to optional, you'll need to do it from FoxPro.

Try these articles for more info on using FoxPro from Access:

ACC2000: "ODBC Call Failed" Error Message Exporting to FoxPro
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q237819

ACC97: How to Use Visual FoxPro DBC Files in Microsoft Access
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q176568

ACC97: Inconsistent Results Are Returned from a Query That Is Based on Linked Visual FoxPro Tables
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q252666

ACC: Index Missing for Attached FoxPro or dBASE Table
http://support.microsoft.com/default.aspx?scid=kb;en-us;q122561

ACC: Adding a FoxPro Index from a Read-Only Drive Causes Error
http://support.microsoft.com/default.aspx?scid=kb;en-us;q153718