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

ID: Q96903

The information in this article applies to:

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

Last Reviewed: March 20, 1999