[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 387
  • Last Modified:

Access 97 ODBC SQLConfig Driver failed

We have a few databases that only work in Access 97. We currently have Access 2003 and/or 2007 installed on XP Pro machines. When I try to install Access 97 from an Office 97  cd it runs through the entire installation then fails with the following error:

ODBC's SQLConfigDriver failed for Microsoft Access driver (*.mdb)

I tried uninstalling office 2003 and office 2007 but get the same error.

Please help!
0
sfghadmin
Asked:
sfghadmin
  • 2
1 Solution
 
tonydemarcoCommented:
Try installing office 97 service pack 1 & 2 before anything else.
These should be obtainable from Microsoft web site.
0
 
souseranCommented:
1. Were you logged in as an administrator on the unit when you installed '97?

2. Windows can be picky about the order in which things are installed. Can you do a system restore to a time when Access wasn't on the PC, then log on as an administrator, and install '97 (including updates and service packs), then 2003 (including updates and service packs), then 2007 (including updates and service packs) in that order?
0
 
sfghadminAuthor Commented:
Thank you. It also required the renaming of the hatten.ttf font as it started saying that there was no license installed.
0
 
sfghadminAuthor Commented:
I was finally able to get the install completed by following the following steps.  I installed Access 97 and when I tried to open it got the error that there was no license for the product on this machine. This is a long-standing registration problem for which the fix is to rename the hatten.ttf font to hatten.xxx, then run a reinstall from the office 97 CD. The install completes correctly. Change the font name back, ran SP 1 and SP2. And now everything works.
I was able to do this while Office 2003 was already installed on my computer.  Thanks everyone!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now