Visual Foxpro application, MS Accesss 2000 with Windows XP.

Tweet

I have to create an application using visual FoxPro 9 to deal with an Access database. I am using ODBC, the access driver version is 4.00.6304.00. When I try to retrieve data via SQL Select: a simple SELECT * FROM _MYtable, I get: "connectivity error: [Microsoft][ODBC Microsoft Access Drive] the Microsoft Jet database engine could not find the object 'field'. Make sure the object exists and that you spell its name and path correctly." 'field' ofcourse exists, it is the last field of the structure of '_MYtable', even if I select specific fields like: SELECT field1,field2,field3 FROM MYTABLE, I got the same message: "....could not find the object 'field3'....". When I run my application on windows 2000, no problem, but on Windows XP, I cannot manage. Could some body give me some tips about?. Thanks Oscar.