Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 7th, 2007, 11:08 AM
Registered User
 
Join Date: May 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Link FoxPro tables through OLEDB

I am able to "Get External Data" using OLEDB provider for Visual FoxPro in Excel 2002 but what I need is to do that from Access.

But Access only shows native or ODBC connections for Linking or Importing tables.

I cannot use the ODBC driver for Visual FoxPro since it does not return correct results. In this regard, I was told that the latest ODBC driver for FoxPro only support up to version 6 and we're using version 9.0.

Any help would greatly be appreciated.

Djinn
 
Old May 8th, 2007, 06:20 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Can you use Provider statements instead of an ODBC connection? Like:

Like

Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\Northwind.mdb;User ID=Admin;Password=???;

Also, take a look at MSDN.

Did that help any?


mmcdonal
 
Old May 8th, 2007, 08:16 AM
Registered User
 
Join Date: May 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The problem with using such code is that it requires opening the .mdb and running an app, at least I think.

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 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.

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?



Djinn





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to link FoxPro Table with VB achour Pro VB Databases 2 September 14th, 2009 09:26 AM
Getting data from link tables psnow1985 SQL Server ASP 0 March 27th, 2008 03:19 PM
CONVERT VISUAL FOXPRO TABLES TO SQL SERVER anantha krishna ADO.NET 1 June 25th, 2007 12:30 PM
Problem connnecting with foxpro tables via OleDb ACE2084 ASP.NET 1.0 and 1.1 Basics 1 November 8th, 2005 12:34 AM
Link Tables thru VBA Rchanga Access 1 November 20th, 2004 11:06 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.