?
Solved

E_FAIL when connecting to Access

Posted on 2002-04-29
10
Medium Priority
?
194 Views
Last Modified: 2010-04-04
Hi guys,
I am getting an E_FAIL error and I have no idea what it means.  I am connecting to an Access database which has queries which query a Foxpro Database.  Any ideas?

Cheers
0
Comment
Question by:gtbikeuk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
10 Comments
 

Author Comment

by:gtbikeuk
ID: 6978374
I've just increased the points as I am desperate to solve this quickly
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6978559
how do you connect?
a bit more info, please
0
 

Author Comment

by:gtbikeuk
ID: 6978744
I'm connecting via ADO
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:gtbikeuk
ID: 6978782
I'm connecting via ADO
0
 
LVL 14

Expert Comment

by:DragonSlayer
ID: 6979243
more information please, e.g. what's your connection string like?

also, how do you query the Foxpro DB from Access? Can access find the Foxpro DB in the first place?
0
 
LVL 17

Expert Comment

by:inthe
ID: 6979627
Put something like this in your connection (use try except block) and hopefully it will tell you more about why its failing.

ShowMessage(SysErrorMessage(GetLastError));
0
 
LVL 4

Expert Comment

by:Greg Rowland
ID: 6981108
Record a macro in Excel or Word,
Connect to the database using the built in dialogs,
Save the macro.
In Excel use Tools, Macros, Visual Basic Editor to examine the connection string it generates.

HTH,

Greg
0
 

Accepted Solution

by:
gtbikeuk earned 0 total points
ID: 6981179
Thanks guys, solved the problem...using ADOQuerys instead of doing it via access...works fine.  Who do you think I should award the points to?
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6981392
no one, or all in splitted parts,
but, i vote for no one

ask at community support,
for taking this q into paq
and refunding your points

meikl ;-)
0
 
LVL 1

Expert Comment

by:pnh73
ID: 9004363
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

PAQ/ Refund

Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
Paul (pnh73)
EE Cleanup Volunteer
0

Featured Post

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month10 days, 3 hours left to enroll

762 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