SYMPTOMS
In Microsoft Access, if you import data by using an indexed sequential access method (ISAM) driver, you may receive the following error message:
ActiveX component cannot create object
You may receive this error message regardless of the data type being imported.
RESOLUTION
Method 1
This method uses the Regsvr32.exe utility to manually register the ISAM drivers. Regsvr32.exe is a program that is used to register dynamic-link libraries (DLLs) and ActiveX controls in the Microsoft Windows registries. This file is usually located in the following folders:
Operating System Location
--------------------------------------
Windows NT, 2000 \Winnt\System32
Windows 95, 98, Me \Windows\System
For example, to manually register a dBASE driver, use the following syntax:
C:\winnt\system32\regsvr32.exe [path]MSXBSE35.DLL
Names of some of the ISAM drivers are listed in the following table:
Driver IISAM file
-----------------------------------
dBASE Msxbse35.dll
Microsoft Excel Msexcl35.dll
Microsoft FoxPro Msxbse35.dll
Paradox Mspdox35.dll
Text Mstext35.dll
Method 2
If the wizards have become corrupted, you need to reinstall them from the Microsoft Office CD-ROM. To do this, follow these steps:
- Locate and rename the following files:
Wzmain80.mde
Wztool80.mde
Wzlib80.mde
For example, rename the file Wzmain80.mde as Wzmain80.old.
- Reinstall Access, including the wizards, from the Microsoft Office CD-ROM.