Article ID: 245407 - View products that this article applies to.
This article was previously published under Q245407
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
After you install the latest service pack for Microsoft Jet 4.0, when you import text files or try to export an Access object to text format, you may receive the following error message:
When importing, this is followed by:
Can't update. Database or object is read-only.
An error occurred trying to import file filename. The file was not imported.
The file that you are importing or that you are trying to export does not have a recognized file name extension.
Rename the file name extension so that it matches one of extensions listed in the "More Information" section later in this article.
Modify the following registry key to include the extension of the file that you are importing.
Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/322756/ )How to back up and restore the registry in Windows
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text\DisabledExtensionsFor additional information about setting this registry key see the More Information section of the following article, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/239471/EN-US/ )Jet 4.0 Text IISAM Allows Users to Append Lines to System Files
For security reasons, the latest service pack for Jet (by default) allows only text files with the following extensions to be imported:
Steps to Reproduce the Behavior