What I'm trying to do is the following.

We have a project management Foxpro application that stores data in 6 separate folders (free tables). We need a program wide report that combines the 6 projects.

I'm using Crystal for reporting. I started by simply linking the FoxPro tables in MS Access (.mdb) using ODBC then created a union query that combined the various project tables together. That scenario never require the user to open the Access database, just running the Crystal report. Access is just used as a go-between.

Everything worked fine until I noticed that Access returned different results on every run. I later learned that ODBC is not supported for VFP beyond v6.

What I would like is to be able to link to the FoxPro tables via OLEDB just as I was linking via ODBC. This mechanism is available in Excel as well as in Word. Why in the world is it not available in Access?

Or I just do not see how to?

I need help quite badly!

Germain