Author Topic: MDAC Not Found in Windows 7  (Read 114585 times)

0 Members and 1 Guest are viewing this topic.

Offline Oceanblue23

  • Newbie
  • *
  • Join Date: Mar 2013
  • Posts: 33
  • Karma: 0
    • View Profile
MDAC Not Found in Windows 7
« on: March 11, 2013, 08:42:37 am »
i have a program that i installed back when i got this computer brand new in july of 2012. it worked fine
until mid January when the computer installed some updates and now the program when tried to start says
MDAC not found and i cant update windows anymore. PLEASE help. This problem is driving me crazy. Thank
you in advance. -Corey

Offline Shane

  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9281
  • Location: USA
  • Karma: 137
  • "Knowledge should be shared not hidden."
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #1 on: March 11, 2013, 11:53:24 am »
MDAC is part of Windows 7, so the first thing to do is a system file check which should replace any missing files. :wink:

Open a cmd window as administrator and run

sfc /scannow

Shane

Offline Oceanblue23

  • Newbie
  • *
  • Join Date: Mar 2013
  • Posts: 33
  • Karma: 0
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #2 on: March 11, 2013, 12:04:07 pm »
i have done that twice and i have used some of the tools and utilities from tweaking.com.
all the sfc /scannow found and replaced were some log files and i then restarted the computer.

Offline Shane

  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9281
  • Location: USA
  • Karma: 137
  • "Knowledge should be shared not hidden."
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #3 on: March 11, 2013, 12:05:50 pm »
Run my MDAC tester from my other site and let me know the results :wink:

http://www.pcwintech.com/shanes-toolbox

It is the 2nd from last at the bottom of the page.

Shane

Offline Oceanblue23

  • Newbie
  • *
  • Join Date: Mar 2013
  • Posts: 33
  • Karma: 0
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #4 on: March 11, 2013, 12:07:23 pm »
i also get this error when running Test MDAC from tweaking

Starting Test.
Date: 3/11/2013 Time: 3:06:12 PM
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Connecting To Test.mdb using DAO...
--Successful
Opening Table...
--Successful
Closing connection to the database.
--Successful
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Connecting To Test.mdb using ADO...
ERROR!: 91 - Object variable or With block variable not set
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Done, Test Complete.
''''''''''''''''''''''''''''''''''''''''''''''''''''''''

Offline Shane

  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9281
  • Location: USA
  • Karma: 137
  • "Knowledge should be shared not hidden."
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #5 on: March 11, 2013, 12:09:24 pm »
OK so the ADO files are missing.

Are you on 64 bit or 32 bit Windows 7?

Shane

Offline Oceanblue23

  • Newbie
  • *
  • Join Date: Mar 2013
  • Posts: 33
  • Karma: 0
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #6 on: March 11, 2013, 12:10:21 pm »
This is an HP Pavillion Dv7 7115 64 bit

Offline Oceanblue23

  • Newbie
  • *
  • Join Date: Mar 2013
  • Posts: 33
  • Karma: 0
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #7 on: March 11, 2013, 12:11:45 pm »
Running Windows 7 with SP1

Offline Shane

  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9281
  • Location: USA
  • Karma: 137
  • "Knowledge should be shared not hidden."
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #8 on: March 11, 2013, 12:13:24 pm »
OK try this.

1. I have attached the ado files from my Windows 7 64bit. Extract them and put them into "C:\Program Files (x86)\Common Files\System\ado" overwrite any files you have there if Windows lets you.
2. Once you have the files there run my mdac repair tool http://www.tweaking.com/content/page/repair_mdac_ms_jet.html
3. Once done try the mdac tester again and lets see if ADO still gives us an error. :wink:

Shane

Offline Oceanblue23

  • Newbie
  • *
  • Join Date: Mar 2013
  • Posts: 33
  • Karma: 0
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #9 on: March 11, 2013, 12:19:04 pm »
The last 11 files say i needed permission

Offline Shane

  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9281
  • Location: USA
  • Karma: 137
  • "Knowledge should be shared not hidden."
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #10 on: March 11, 2013, 12:20:16 pm »
If you cant replace them that is ok, as long as any missing files got put there is what is important :-)

Shane

Offline Oceanblue23

  • Newbie
  • *
  • Join Date: Mar 2013
  • Posts: 33
  • Karma: 0
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #11 on: March 11, 2013, 12:24:28 pm »
ok i ran the repair tool after trying to install the files.

Offline Shane

  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9281
  • Location: USA
  • Karma: 137
  • "Knowledge should be shared not hidden."
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #12 on: March 11, 2013, 12:25:38 pm »
OK, and what did the tester say after that?

Shane

Offline Oceanblue23

  • Newbie
  • *
  • Join Date: Mar 2013
  • Posts: 33
  • Karma: 0
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #13 on: March 11, 2013, 12:26:04 pm »
Starting Test.
Date: 3/11/2013 Time: 3:25:33 PM
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Connecting To Test.mdb using DAO...
--Successful
Opening Table...
--Successful
Closing connection to the database.
--Successful
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Connecting To Test.mdb using ADO...
ERROR!: 91 - Object variable or With block variable not set
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Done, Test Complete.
''''''''''''''''''''''''''''''''''''''''''''''''''''''''

Offline Oceanblue23

  • Newbie
  • *
  • Join Date: Mar 2013
  • Posts: 33
  • Karma: 0
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #14 on: March 11, 2013, 12:30:03 pm »
here is what the repair tool said as well:
Log:
Repair MDAC & MS Jet
   Start (3/11/2013 3:23:39 PM)
   Running Repair Under Current User Account
   Running Repair Under System Account
   Done (3/11/2013 3:23:45 PM)

   Total Repair Time: 00:00:06

Offline Shane

  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9281
  • Location: USA
  • Karma: 137
  • "Knowledge should be shared not hidden."
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #15 on: March 11, 2013, 12:32:13 pm »
Something else is wrong then if that didnt fix it and a system file check didnt fix it.

This is why in any of my database programs I have it set to use DAO and if it fails to use ADO. This way when one is broken it will use the other.

In this case what ever happened to ADO must have deleted something from the registry. But I dont know what keys it would need.

Have you ever done a repair install of Windows before? It is where Windows get reinstalled but all your files, programs and settings are saved.

Shane

Offline Oceanblue23

  • Newbie
  • *
  • Join Date: Mar 2013
  • Posts: 33
  • Karma: 0
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #16 on: March 11, 2013, 12:36:27 pm »
i have tried doing a repair install but it gets to the end and then fails
so i go back to the same exact thing. i really hate microsoft updates.

Offline Shane

  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9281
  • Location: USA
  • Karma: 137
  • "Knowledge should be shared not hidden."
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #17 on: March 11, 2013, 12:38:01 pm »
Whats the error when you try to do a repair install?

Shane

Offline Oceanblue23

  • Newbie
  • *
  • Join Date: Mar 2013
  • Posts: 33
  • Karma: 0
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #18 on: March 11, 2013, 12:39:21 pm »
i get a blue screen of death with an irq error but i cant read it cuz its really fast

Offline Shane

  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9281
  • Location: USA
  • Karma: 137
  • "Knowledge should be shared not hidden."
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #19 on: March 11, 2013, 12:41:19 pm »
IRQ equal or less than blue screen of death. And since you have Windows set to auto reboot on a blue screen you cant read the rest.

That is almost always driver related.

Shane

Offline Oceanblue23

  • Newbie
  • *
  • Join Date: Mar 2013
  • Posts: 33
  • Karma: 0
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #20 on: March 11, 2013, 12:42:04 pm »
okay how can i take care of that problem?

Offline Shane

  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9281
  • Location: USA
  • Karma: 137
  • "Knowledge should be shared not hidden."
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #21 on: March 11, 2013, 12:46:26 pm »
Not sure since I cant see the system.

I would say unhook anything that doesnt need to be on during the repair install, uninstall any antivirus or firewall software as they add their own drivers tot eh system.

And have Windows set to not restart on a blue screen so if it happens again we can get the full error and hopefuly findout which is causing it.

Oh and you can try this tool, it will report the last blue screen and which file or driver might have caused it :-)

http://www.resplendence.com/whocrashed

Shane

Offline Oceanblue23

  • Newbie
  • *
  • Join Date: Mar 2013
  • Posts: 33
  • Karma: 0
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #22 on: March 11, 2013, 12:48:15 pm »
how do i set windows to not restart after blue screen automatically?

Offline Shane

  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9281
  • Location: USA
  • Karma: 137
  • "Knowledge should be shared not hidden."
    • View Profile

Offline Oceanblue23

  • Newbie
  • *
  • Join Date: Mar 2013
  • Posts: 33
  • Karma: 0
    • View Profile
Re: MDAC Not Found in Windows 7
« Reply #24 on: March 11, 2013, 12:56:35 pm »
Okay Thank you so much. I am going to try a Windows Repair and will let you know what kind of animal we are dealing with.
Thank you again so much for your help.