ACC1x: '#' Appears in Attached Table Name in Error Message

ID: Q96903

The information in this article applies to:

Microsoft Access 1.0

SYMPTOMS

In certain error messages, a number sign (#) instead of a period appears as a file extension separator. For example, this message may appear:

Couldn't open file 'PDXSALES#DB'

instead of this message:

Couldn't open file 'PDXSALES.DB'

This problem occurs in errors that are generated while attempting to attach an external table that uses an installable ISAM driver (as seen in the [Installable ISAMs] section of the MSACCESS.INI file in the WINDOWS directory.)

CAUSE

Internally, an installable ISAM driver replaces the period in the table name with a number sign for database compatibility purposes.

The problem is caused when Microsoft Access uses this internal number sign-separated table filename in the error message, instead of the period-separated name.

This is a cosmetic problem only; it does not affect the operation of the installable ISAM driver or the attaching of external tables.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 1.0. This problem was corrected in Microsoft Access version 1.1.

Keywords : kbinterop IsmExl4
Version : 1.0
Platform : WINDOWS
Issue type : kbbug