asked on

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

gtbikeuk

ASKER

I've just increased the points as I am desperate to solve this quickly

kretzschmar

how do you connect?
a bit more info, please

gtbikeuk

ASKER

I'm connecting via ADO

gtbikeuk

ASKER

I'm connecting via ADO

DragonSlayer

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?

inthe

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));

Calvin Day

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

ASKER CERTIFIED SOLUTION

gtbikeuk

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

kretzschmar

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 ;-)

pnh73

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