E_FAIL when connecting to Access

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
gtbikeukAsked:
Who is Participating?
 
gtbikeukConnect With a Mentor Author Commented:
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
 
gtbikeukAuthor Commented:
I've just increased the points as I am desperate to solve this quickly
0
 
kretzschmarCommented:
how do you connect?
a bit more info, please
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
gtbikeukAuthor Commented:
I'm connecting via ADO
0
 
gtbikeukAuthor Commented:
I'm connecting via ADO
0
 
DragonSlayerCommented:
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
 
intheCommented:
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
 
Greg RowlandSoftware Designer, SysDBA, WebMaster OwnerCommented:
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
 
kretzschmarCommented:
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
 
pnh73Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.