Could Not Find Installable Isam. Number 3170

  • ERROR: Could not find installable ISAM. When trying to perform an Open. I have a large number of Office 2007 Excel Workbooks that I need to extract a sheet of data (it has a header row) and move that contents to a SQL Server 2005 database.
  • Apr 19, 2018  I got the 'Could Not find installable ISAM error' while uploading an Excel file in my application. The connection string uses the Microsoft.Jet.OLEDB.4.0 provider with following parameters Provider=Microsoft.Jet.OLEDB.4.0;Excel 8.0; Extended Properties=HDR=No; IMEX=1.

'Could Not Find Installable ISAM' While Refreshing Access Query Connection. Microsoft Office. I have the Same issue but did not have any solution. I have reinstall the access redistributable for 2010 but it did not fixed the issue Any other plan will help me a lot.

Hello all. I need your help with an error.
Working with an Access database created in the office 2000 format on a computer with Access 2007 installed.
When running the following import function (if toolbox mangles this you can find a copy at http://www.freakzilla.net/samples/function.txt) I receive the error 3170 could not find installable ISAM.
This code opens a file dialog box, allows the selection of XLS files and after clearing out a table, imports the excel data into an access table.
The error comes up immediately after the old table data is cleared
The routine runs without error on older versions of access.
Private Sub importOne_Click()
On Error GoTo Err_importOne_Click
Dim dDlg As Office.FileDialog
Dim vFilename As Variant
Set dDlg = Application.FileDialog(msoFileDialogFilePicker)
With dDlg
.AllowMultiSelect = True
.InitialFileName = 'J:a_path'
.TITLE = 'Choose import files'
.Filters.Clear
.Filters.Add 'Microsoft Excel Files', '*.XLS'
If .Show = True Then
DoCmd.OpenQuery 'ImportDelete', acViewNormal, acEdit ' clear out existing records
For Each vFilename In .SelectedItems
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel, 'ImportOne', vFilename, True
Next vFilename
DoCmd.OpenQuery 'OneImportquery'
Else
'the import dialog was canceled
End If
End With
Exit_importOne_Click:
Exit Sub
Err_importOne_Click:
MsgBox Err.Number & Err.Description
Resume Exit_importOne_Click
End Sub

I have re registered Msrd3x40.dll and Msexcl40.dll. I have run the office diagnostic with no results.
This error happens on computers running Office 2007 on Server 2003, XP, and Windows 7.
Google doesn't seem to find help and the ITtoolbox discussions so far on this error haven't helped.

Error Number: Error 3170
Error Name:Microsoft Access Error 3170
Error Description: Could not find installable ISAM.
Developer:Microsoft Corporation
Software:Microsoft Access
Applies to:Windows XP, Vista, 7, 8

Compatible with Windows 10, 8, 7, Vista, XP and 2000

Could Not Find Installable Isam. Number 3170

Optional Offer for WinThruster by Solvusoft | EULA | Privacy Policy | Terms | Uninstall

Symptoms of Error 3170

  • 'Error 3170' appears and crashes the active program window.
  • Your PC frequently crashes with Error 3170 when running the same program.
  • “Microsoft Access Error 3170” is displayed.
  • Windows runs sluggishly and responds slowly to mouse or keyboard input.
  • Your computer periodically “freezes” for a few seconds at a time.

These 3170 error messages can appear during program installation, while a Microsoft Corporation-related software program (eg. Microsoft Access) is running, during Windows startup or shutdown, or even during the installation of the Windows operating system. Keeping track of when and where your 3170 error occurs is a critical piece of information in troubleshooting the problem.

Causes of Error 3170

  • Corrupt download or incomplete installation of Microsoft Access software.
  • Corruption in Windows registry from a recent Microsoft Access-related software change (install or uninstall).
  • Virus or malware infection that has corrupted Windows system files or Microsoft Access-related program files.
  • Another program maliciously or mistakenly deleted Microsoft Access-related files.

Runtime Errors such as “Error 3170” can be caused by a variety of factors, so it is important that you troubleshoot each of the possible causes to prevent it from recurring.

Isam.


Runtime Errors Knowledgebase

Article ID:

125891

Article Author:

Last Updated:

Popularity:

star rating here


Could Not Find Installable Isam Visual Basic

Optional Offer for WinThruster by Solvusoft
EULA | Privacy Policy | Terms | Uninstall



Recommendation:

Could Not Find Installable Isam Excel 2016

Scan your PC for computer errors.

Optional Offer for WinThruster by Solvusoft | EULA | Privacy Policy | Terms | Uninstall

Below is a list of troubleshooting steps to resolve your Error 3170 problems. These troubleshooting steps get progressively more difficult and time consuming, so we strongly recommend attempting them in ascending order to avoid unnecessary time and effort.


Please Note: Click the [ ] image to expand the troubleshooting instructions for each step below. You can also click the [ ] image to hide the instructions as you proceed through each step.

Step 1: Repair Registry Entries Associated with Error 3170


Manually editing the Windows registry to remove invalid Error 3170 keys is not recommended unless you are PC service professional. Incorrectly editing your registry can stop your PC from functioning and create irreversible damage to your operating system. In fact, one misplaced comma can prevent your PC from booting entirely!

Because of this risk, we highly recommend using a trusted registry cleaner such as WinThruster [download] (Developed by Microsoft Gold Certified Partner) to scan and repair any Error 3170-related registry problems. Using a registry cleaner [download] automates the process of finding invalid registry entries, missing file references (like the one causing your 3170 error), and broken links within the registry. A backup is automatically created before each scan, with the ability to undo any changes in a single click, protecting you against the possibility of PC damage. The best part is that repairing registry errors [download] can also dramatically improve system speed and performance.


Caution: Unless you an advanced PC user, we DO NOT recommend editing the Windows registry manually. Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows. We do not guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

To manually repair your Windows registry, first you need to create a backup by exporting a portion of the registry related to Error 3170 (eg. Microsoft Access):

  1. Click the Start button.
  2. Type 'command' in the search box... DO NOT hit ENTER yet!
  3. While holding CTRL-Shift on your keyboard, hit ENTER.
  4. You will be prompted with a permission dialog box.
  5. Click Yes.
  6. A black box will open with a blinking cursor.
  7. Type 'regedit' and hit ENTER.
  8. In the Registry Editor, select the Error 3170-related key (eg. Microsoft Access) you want to back up.
  9. From the File menu, choose Export.
  10. In the Save In list, select the folder where you want to save the Microsoft Access backup key.
  11. In the File Name box, type a name for your backup file, such as 'Microsoft Access Backup'.
  12. In the Export Range box, be sure that 'Selected branch' is selected.
  13. Click Save.
  14. The file is then saved with a .reg file extension.
  15. You now have a backup of your Microsoft Access-related registry entry.

The next steps in manually editing your registry will not be discussed in this article due to the high risk of damaging your system. If you would like to learn more about manual registry editing, please see the links below.


We do not claim any responsibility for the results of the actions taken from the content linked below - complete these tasks at your own risk.

Windows XP
http://www.theeldergeek.com/windows_xp_registry.htm

Windows 7
http://www.theeldergeek.com/windows_7/registry_edits_for_win7.htm

Windows Vista
http://support.microsoft.com/kb/2688326 - LetMeFixItMyselfAlways


Step 2: Conduct a Full Malware Scan of Your PC


There is a chance that your 3170 error could be related to a malware infection on your PC. These malicious intruders can damage, corrupt, or even delete Runtime Errors-related files. Furthermore, there's a possibility that the 3170 error you are experiencing is related to a component of the malicious program itself.


Tip: If you do not already have a malware protection program installed, we highly recommend using Emsisoft Anti-Malware (download here). They offer a malware removal guarantee that is not offered by other security software.


Step 3: Clean Out Your System Junk (Temporary Files and Folders) With Disk Cleanup (cleanmgr)


Over time, your computer accumulates junk files from normal web surfing and computer use. If this junk isn't occasionally cleaned out, it can cause Microsoft Access to respond slowly or provides an 3170 error, possibly due to file conflicts or an overloaded hard drive. Cleaning up these temporary files with Disk Cleanup might not only solve your 3170 error, but can also dramatically speed up the performance of your PC.


Tip: Although Disk Cleanup is a wonderful built-in tool, it will not completely clean up all of the temporary files on your computer. Other programs that you frequently use such Microsoft Office, Firefox, Chrome, Live Messenger, and hundreds of other programs are not cleaned up with Disk Cleanup (including some Microsoft Corporation programs).


Because of the shortcomings of the Windows Disk Cleanup (cleanmgr) tool, we highly recommend using a specialized hard drive cleanup / privacy protection software such as WinSweeper [download] (Developed by Microsoft Gold Partner) to clean up your entire computer. Running WinSweeper [download] once per day (using automatic scanning) will ensure that your computer is always clean, running fast, and free of 3170 errors related to temporary files.

How to run Disk Cleanup (cleanmgr) (Windows XP, Vista, 7, 8, and 10):

  1. Click the Start button.
  2. Type 'command' in the search box... DO NOT hit ENTER yet!
  3. While holding CTRL-Shift on your keyboard, hit ENTER.
  4. You will be prompted with a permission dialog box.
  5. Click Yes.
  6. A black box will open with a blinking cursor.
  7. Type 'cleanmgr' and hit ENTER.
  8. Disk Cleanup will begin calculating how much occupied disk space you can reclaim.
  9. The Disk Cleanup dialog box will appear with series of checkboxes you can select. In most cases, the 'Temporary Files' category will occupy the most disk space.
  10. Check the boxes of the categories you want to clean and click OK.

Step 4: Update Your PC Device Drivers


3170 errors can be related to corrupt or outdated device drivers. Drivers can work one day, and suddenly stop working the next day, for a variety of reasons. The good news is that you can often update the device driver to fix the Error 3170 problem.

Finding the exact driver for your Error 3170-related hardware device can be extremely difficult, even directly on the Microsoft Corporation or related manufacturer's website. Even if you are experienced at finding, downloading, and manually updating drivers, the process can still be very time consuming and extremely irritating. Installing the wrong driver, or simply an incompatible version of the right driver, can make your problems even worse.

Because of the time and complexity involved in updating drivers, we highly recommend using a driver update tool such as DriverDoc (Developed by Microsoft Gold Partner) to automate the process.

DriverDoc updates all of your PC device drivers, not just those associated with your 3170 error. DriverDoc's proprietary One-Click Update™ technology not only ensures that you have correct driver versions for your hardware, but it also creates a backup of your current drivers before making any changes. Maintaining a driver backup provides you with the security of knowing that you can rollback any driver to a previous version if necessary. With updated device drivers, you can finally unlock new hardware features and improve the speed and performance of your PC.


Please Note: Your Error 3170 may not be related to hardware driver problems, but it's always a good idea to ensure all of your PC device drivers are up-to-date to maximize PC performance.


Step 5: Utilize Windows System Restore to 'Undo' Recent System Changes


Windows System Restore allows you to 'go back in time' with your PC to help fix your Error 3170 problems. System Restore can return your PC's system files and programs back to a time when everything was working fine. This can potentially help you avoid hours of troubleshooting headaches associated with 3170 errors.


Please Note: Using System Restore will not affect your documents, pictures, or other data.

To use System Restore (Windows XP, Vista, 7, 8, and 10):

  1. Click the Start button.
  2. In the search box, type 'System Restore' and hit ENTER.
  3. In the results, click System Restore.
  4. Enter any administrator passwords (if prompted).
  5. Follow the steps in the Wizard to choose a restore point.
  6. Restore your computer.

Step 6: Uninstall and Reinstall the Microsoft Access Program Associated with Error 3170


If your 3170 error is related to a specific program, reinstalling Microsoft Access-related software could be the answer.

Instructions for Windows 7 and Windows Vista:

  1. Open Programs and Features by clicking the Start button.
  2. Click Control Panel on the right side menu.
  3. Click Programs.
  4. Click Programs and Features.
  5. Locate Microsoft Access Error 3170-associated program (eg. Microsoft Access) under the Name column.
  6. Click on the Microsoft Access-associated entry.
  7. Click the Uninstall button on the top menu ribbon.
  8. Follow the on-screen directions to complete the uninstallation of your Error 3170-associated program.

Instructions for Windows XP:

  1. Open Programs and Features by clicking the Start button.
  2. Click Control Panel.
  3. Click Add or Remove Programs.
  4. Locate Microsoft Access Error 3170-associated program (eg. Microsoft Access) under the list of Currently Installed Programs.
  5. Click on the Microsoft Access-associated entry.
  6. Click the Remove button on the right side.
  7. Follow the on-screen directions to complete the uninstallation of your Error 3170-associated program.

Instructions for Windows 8:

  1. Hover the cursor in the bottom left of the screen to produce the Start Menu image.
  2. Right-Click to bring up the Start Context Menu.
  3. Click Programs and Features.
  4. Locate Microsoft Access Error 3170-associated program (eg. Microsoft Access) under the Name column.
  5. Click on the Microsoft Access-associated entry.
  6. Click the Uninstall/Change on the top menu ribbon.
  7. Follow the on-screen directions to complete the uninstallation of your Error 3170-associated program.

After you have successfully uninstalled your Error 3170-associated program (eg. Microsoft Access), reinstall the program according to the Microsoft Corporation instructions.


Tip: If you are positive that your 3170 error is related to a specific Microsoft Corporation program, uninstalling and reinstalling your Error 3170-related program will likely be the solution to your problem.


Step 7: Run Windows System File Checker ('sfc /scannow')


System File Checker is a handy tool included with Windows that allows you scan for and restore corruptions in Windows system files (including those related to Error 3170).

To run System File Checker (Windows XP, Vista, 7, 8, and 10):

  1. Click the Start button.
  2. Type 'command' in the search box... DO NOT hit ENTER yet!
  3. While holding CTRL-Shift on your keyboard, hit ENTER.
  4. You will be prompted with a permission dialog box.
  5. Click Yes.
  6. A black box will open with a blinking cursor.
  7. Type 'sfc /scannow' and hit ENTER.
  8. System File Checker will begin scanning for Error 3170 and other system file problems (be patient - the system scan may take a while).
  9. Follow the on-screen commands.

Step 8: Install All Available Windows Updates


Microsoft is constantly updating and improving Windows system files that could be associated with Error 3170. Sometimes resolving your Runtime Errors problems may be as simple as updating Windows with the latest Service Pack or other patch that Microsoft releases on an ongoing basis.

To check for Windows Updates (Windows XP, Vista, 7, 8, and 10):

  1. Click the Start button.
  2. Type 'update' into the search box and hit ENTER.
  3. The Windows Update dialog box will appear.
  4. If updates are available, click the Install Updates button.

Step 9: Perform a Clean Installation of Windows


Caution: We must emphasize that reinstalling Windows will be a very time-consuming and advanced task to resolve Error 3170 problems. To avoid data loss, you must be sure that you have backed-up all of your important documents, pictures, software installers, and other personal data before beginning the process. If you are not currently backing up your data, you need to do so immediately (download a highly-recommended backup solution) to protect yourself from permanent data loss.

This step is your final option in trying to resolve your Error 3170 issue. Reinstalling Windows will erase everything from your hard drive, allowing you to start again with a fresh system. Furthermore, a clean install of Windows will also quickly clean out any and all 'junk' that has accumulated over the normal usage of your computer.


Please Note: If 3170 errors still persist after a clean install of Windows, your Runtime Errors problem MUST be hardware related. If that is the case, then it is likely you will need to replace the associated hardware causing the 3170 error.


Recommendation:Scan your PC for computer errors.

Optional Offer for WinThruster by Solvusoft | EULA | Privacy Policy | Terms | Uninstall


Operating System Information

3170 error messages can occur in any of the following Microsoft Windows operating systems:

Couldn't Find Installable Isam

  • Windows 10
  • Windows 8
  • Windows 7
  • Windows Vista
  • Windows XP
  • Windows ME
  • Windows 2000

Are You Still Experiencing Error 3170 Issues?

Please reach out to us anytime on social media for more help:


Optional Offer for WinThruster by Solvusoft | EULA | Privacy Policy | Terms | Uninstall


Recommendation:Scan your PC for computer errors.

Optional Offer for WinThruster by Solvusoft | EULA | Privacy Policy | Terms | Uninstall

Runtime Error 3170 Installable Isam

About The Author:Jay Geater is the President and CEO of Solvusoft Corporation, a global software company focused on providing innovative utility software. He is a lifelong computer geek and loves everything related to computers, software, and new technology.


Excel Could Not Find Installable Isam

Browse Errors in Alphabetical Order: