Today, my colleague came over and talked about it for a while. He started to work on a VB + Access software and installed and run normally under win2000. However, a problem occurred in WINXP and the database could not be opened. MDAC 2.8 cannot be installed either. After confirmation, the sp2 patch package is installed in WINXP. So I found some information online and found the following problems:
1. mdac2.8 installation problem www.shengfang.org
In Windows XP + SP2, the following message is displayed during installation: "MDAC 2.8 RTM is incompatible with this version of Windows ". Solution: all functions of mdac2.8 are now part of Windows XP SP2. This prompt is normal and will not affect usage.
Your system is WINXP-SP2, the system comes with MDAC 2.8 SP2, so you cannot install MDAC 2.8, And the WINXP-SP2 Cannot uninstall MDAC, which is the core part of the system, you can only upgrade your MDAC by installing the Service Pack and cannot roll back to the previous version of MDAC. www.shengfang.org
If you install the downloaded version of Microsoft Data Access Components (MDAC) version 2.8 to a Microsoft Windows XP Service Pack 2-based computer, you receive the following error message :? Www.shengfang.org
If you have installed and downloaded the MDAC Microsoft Data Access Component version 2.8 and installed it on the WINXP SP2 machine, you will receive the following error message:
This version is incompatible with the version you are attempting to install. This version of MDAC 2.8 RTM is incompatible with your windows system version and the software version you are about to install.
Method 1: Install MDAC 2.81 method 1 install MDAC 2.81
For information about how to install MDAC 2.81, visit the following Microsoft Web site:
Http://msdn.microsoft.com/data/mdac/downloads/default.aspx (http://msdn.microsoft.com/data/mdac/downloads/default.aspx)
Note This redistributable installer for the MDAC 2.8 SP1 release INSTALLThe same Data Access Components that Windows XP SP2 instals. For information about how to install mdac2.81, visit. The mdac2.8 SP1 distribution installation package and WINXP SP2 are installed with the same data access component.
Method 2: repair the MDAC 2.81 installation that is already ded with Windows XP SP2
1. in Windows Explorer, open the C:/Windows/INF folder. method 2 install www.shengfang.org on the MDAC 2.81 that comes with WINXP SP2
Note if you cannot see the C:/Windows/INF folder, follow these steps: .? Click Start, click my computer, and then click Folder Options on the Tools menu. If you cannot see the Windows INF directory, perform the following steps and click Start My Computer Tools menu Folder Options
B .? Click the view tab .? Click to view www.shengfang.org
C .? Under advanced settings, click show hidden files and folders .? Under advanced settings, click show hidden files and folders
D .? Click to clear the hide extensions for known file types check box .? Remove the option to hide the extension of a known file.
E .? Click Apply, and then click OK .? Www.shengfang.org click Application and click OK.
?
2. In the C:/Windows/INF folder, right-click the MDAC. inf file, and then click Install .? In the Windows INF directory, right-click MDAC. inf and choose install
3. When you are prompted to insert the Windows XP SP2 CD, use one of the following methods :? A .? Insert the Windows XP Service Pack 2 cd in the CD or DVD drive. When you are prompted to insert the WINXP SP2 disc, www.shengfang.org? Select the following method to insert the disc to the optical drive
Note if a "Welcome to Microsoft Windows XP" message appears, click exit .? If you are welcome to use WINXP, click to exit
B .? Click Browse .? Click Browse
C .? In the file name box, type CD or DVD drive that contains the Windows XP Service Pack 2 CD drive letter:/ITER. For example, type D: /i386 if the Windows XP Service Pack 2 CD is in drive D .? Enter the drive letter in the file name, including the i386 directory. If your drive is a drive D, enter D:/WINXP.
D .? Click Open .? Click to open www.shengfang.org
?
? In the file name box, type % SystemRoot %/Windows/servicepackfiles/i386, and then click open .? Alternatively, enter % SystemRoot %/Windows/servicepackfiles/i386 and click open.
?
4. You may also be prompted for the original Windows xp cd that was used to install the operating system. .? Insert the Windows XP Service Pack 2 cd in the CD or DVD drive.
Note if a "Welcome to Microsoft Windows XP" message appears, click exit .?
B .? Click Browse.
C .? In the file name box, type CD or DVD drive that contains the Windows XP Service Pack 2 CD drive letter:/ITER. For example, type D: /i386 if the Windows XP Service Pack 2 CD is in drive D .?
D .? Click Open .? Www.shengfang.org
?
You may also be prompted to insert a WINXP SP2 disc for system installation.
It is estimated that this will solve the problem of accessing the ADO database.
The Data Access core components installed in MDAC 2.8 SP1 are the same as Microsoft SQL Server OLE DB provider and ODBC driver. MDAC 2.8 SP1 is the final distribution installer for installing the same core components as Microsoft Windows XP SP2 with data access. Http://support.microsoft.com/default.aspx? SCID = KB; en-US; 899861? This version does not include Microsoft Jet, Microsoft jet ole db provider, desktop database drivers ODBC driver, or Visual FoxPro ODBC driver.