Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

VFP ODBC missing one file

VFP ODBC missing one file

VFP ODBC missing one file

I have four .dbf files that I set up an ODBC for, using the VPF driver.  When I selected the path in the ODBC setup, it showed me all four files.  However, when I try to use it in Crystal Reports or Access, it only shows three.

I am able to open the fourth file in Excel, so I don't think it is corrupted.

What else could it be?

RE: VFP ODBC missing one file

There are a couple of issues that could be causing this.

First, you have to distinguish between "free" tables and "database" tables. They are both DBFs, but a free table is a DBF that stands alone, where as a database table is one that can only exist as part of a database "container", which is a DBC file.

The point is that the VFP ODBC driver treats these different types of  tables differently. You can see there's a "database type" option in the ODBC setup dialogue. You have to make sure you choose the correct setting, and in general you can't mix the two different types in the same DSN.

Secondly, check which version of VFP was used to create the tables. The VFP ODBC driver hasn't been updated since VFP was at version 6, which was three major releases ago. If the DBFs use any features introduced in recent versions, the driver won't be able to access the files.

The general advice for people wanting to access VFP data is to use the OLE DB provider rather than the ODBC driver.

Hope this helps.


Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close