Solved

Foxpro to Access ODBC problem

Posted on 2000-04-28
3
600 Views
Last Modified: 2008-02-01
I need to link to Foxpro files that reside on my hard drive using Access 2000.  The foxpro option is not in my picklist of all file types, so I must use ODBC since a regular DBase does not work.

Everything goes fine and the tables are linked in using the ODBC driver.  The table opens and data can be viewed and entered, etc.

But when I go to build a query from the tables I get an error message at runtime like below:

ODBC--call failed.
[Microsoft][ODBC Visual FoxPro Driver]cannot open (#171) etc..
or
Could not find linked table..

I need help pretty bad.  Does anyone know what's wrong??

Thanks!
0
Comment
Question by:EdCo
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
paasky earned 50 total points
ID: 2762646
Hello EdCo,

There was no direct answer or fix for your problem in MS KB, but you could look these articles and check your Visual FoxPro ODBC driver is Access 2K compliant (get the latest version and install hotfixes is necessary).

Latest driver bug:
http://support.microsoft.com/support/kb/articles/Q231/7/14.ASP?LN=EN-US&SD=gn&FR=0

Union query bug:
http://support.microsoft.com/support/kb/articles/Q244/9/04.ASP?LN=EN-US&SD=gn&FR=0

You could also change your queries to pass-thru queries (Query | SQL Specific -> Pass-through) and see if that will fix the problem. Note that you can provide Connect String (for eg. ODBC;DSN=mydatabase;UID=scott;PWD=tiger) in query properties if you don't want see login prompt every time you run the query.

Hope this helps,
Paasky
0
 
LVL 2

Expert Comment

by:repstein
ID: 2763130
Are you using the Visual FoxPro driver to link to your FoxPro 2.5 or 2.6 tables? This is the recommended way to do this.

Richard
0
 
LVL 10

Expert Comment

by:paasky
ID: 2766693
Glad I was able to help you EdCo.

Regards,
Paasky
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Need to filter query and have subform updatable 2 28
Create a EXCEL FIle from Access Procedure 1 20
Access check if a table is open 4 43
Dcount help 2 17
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

822 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question