Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
QUERYING VFP DATABASE USING ACCESS 2007
 From: Jim Lloyd
  Where is Jim Lloyd?
 Hove
 United Kingdom
 Jim Lloyd
 Tags
Subject: Querying VFP database using Access 2007
Thread ID: 204753 Message ID: 204753 # Views: 31 # Ratings: 0
Version: Not Applicable Category: ODBC, ADO and OLEDB
Date: Sunday, November 23, 2008 9:21:48 AM         
   

Hello,

I'm attempting to query a VFP database from Access 2007. When I try to import from a table using 'external data > more > ODBC database' I can choose the table from the database but I'm presented with an error message saying

'Invalid field definition 'DELETED()' in definition of index or relationship'.

Any thoughts as to what's causing this would be much appreciated. I've successfully queried the database using Excel, but I'd like to be able to make more presentable reports based on the query.

I'm connecting using the Visual FoxPro Driver under 'machine data sources'.

Many thanks

Jim



COMPLETE THREAD
Querying VFP database using Access 2007 Posted by Jim Lloyd @ 11/23/2008 9:21:48 AM
RE: Querying VFP database using Access 2007 Posted by M. Akram Bhatti @ 11/23/2008 10:22:29 AM
RE: Querying VFP database using Access 2007 Posted by Anders Altberg @ 11/23/2008 11:07:23 AM
RE: Querying VFP database using Access 2007 Posted by Jim Lloyd @ 11/23/2008 11:56:26 AM
RE: Querying VFP database using Access 2007 Posted by Anders Altberg @ 11/23/2008 1:03:52 PM
RE: Querying VFP database using Access 2007 Posted by Cetin Basoz @ 11/23/2008 2:09:36 PM
RE: Querying VFP database using Access 2007 Posted by Jim Lloyd @ 11/23/2008 6:50:00 PM
RE: Querying VFP database using Access 2007 Posted by Cetin Basoz @ 11/24/2008 12:50:53 AM