"Installable ISAM not found" connection access

Source: Internet
Author: User
Today, I suddenly wanted to write a connection to the access database. Solution: 2. dataSource in the connection string should not be connected together, and a space is required in the middle. DataSource also has the access database Suffix: mdb; MSSQL master database Suffix: mdf times: ndf log: ldf Problem description: in Access or SqlServe

Today, I suddenly wanted to write a connection to the access database. Solution: 2. dataSource in the connection string should not be connected together, and a space is required in the middle. Data Source and access Database Suffix: mdb; MSSQL primary database Suffix: mdf times: ndf log: ldf Problem description: in Access or SQL Serve

Today, I suddenly wanted to write a connection to the access database. Solution:

2. DataSource in the connection string should not be connected together. A space is required in the middle, "Data Source"

The access Database suffix mdb and MSSQL primary database suffix mdf times: ndf log: ldf

Problem description:

The "cocould not find installable ISAM" error message is received in Access or SQL Server, or some file classes are lost.

Solution:

1. Improper use of the Registry Editor may cause serious problems and you may need to reinstall the operating system. Microsoft cannot guarantee that you can solve problems caused by improper use of the Registry Editor. You are at your own risk to use the Registry Editor. To solve this problem, you can try to manually register this file, or you must correct the path name in the Windows registry and then install or replace the problem file. To do this, follow these steps.

Note:: In error message 1 mentioned in the "Symptom" section, the file name is directly associated with the operation you are trying. The file name is mentioned in the text of the error message 2 mentioned in the "Symptom" section.

1. Find the relevant file in the following table: file name import/export ISAM: Windows Registry
Msexcl40.dll Microsoft Excel HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Jet/4.0/Engines/Excel
Msexch40.dll Microsoft Exchange HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Jet/4.0/Engines/Exchange
Msrd2x40. dll Microsoft Jet 2.x HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Jet/4.0/Engines/Jet 2.x
Msrd3x40. dll Microsoft Jet 3.x HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Jet/4.0/Engines/Jet 3.x
Msltus40.dll Lotus 1-2-3 HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Jet/4.0/Engines/Lotus
Mspbde40.dll Imprise Paradox HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Jet/4.0/Engines/Paradox
Mstext40.dll Text HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Jet/4.0/Engines/Text
Msxbde40.dll dBase HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Jet/4.0/Engines/Xbase

2. Use Microsoft Windows Resource Manager to search for files.
3. If the file is found, write down the path name of the file. If the file cannot be found, go to step 13.
4. Open the Windows Registry Editor.
5. Find the Registry subitem described in this table and check the path name according to the actual path name. If this registry key does not exist, go to Step 8.
6. If the path is incorrect, correct the path. If the path is correct, continue with these steps.
7. Disable Registry Editor.

If you change this path, repeat the initial error process.
8. If the error persists, use the Regsvr32.exe utility to manually register the file.

Regsvr32.exe utility is used to register DLL and ActiveX controls in the Windows registry. You can use this file to solve the problem of incorrect matching. dll files. To use the Regsvr32.exe utility to re-register the. dll file, go to the next step.
9. Verify that the Regsvr32.exe file is in a Windows system folder.

For example, the regsvr32.exe file is usually located in C:/Windows/System or C:/Winnt/System32.
10. Click start and then click Run ".
11. In the "run" dialog box, type the following command in the "open" box.

Note: The name and path of Regsvr32.exe may be different in the computer. Run the following command to register an Excel ISAM:

Regsvr32 c:/winnt/system32/msexcl40.dll

Note: another way to register a DLL is to use Windows Resource Manager to find the DLL.

Double-click this DLL. In the "publish" dialog box, click "regsvr32.exe" and click "OK ".

This creates a permanent association between all DLL and Regsvr32.exe. You can double-click another unregistered DLL to register the DLL.

For more information about how to obtain this file, click the following article number to view the article in the Microsoft Knowledge Base:
267279 (http://support.microsoft.com/kb/267279/) Regsvr32.exe can be downloaded from the download center
12. If the error persists or the path name has been corrected in step 5, rename the file.
13. Start the "Add/delete programs" tool, start the Office 2000 installer, and then click "repair Office ".

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.