MSQuery: Access Database Created Even After Choosing Cancel

ID: Q121864


The information in this article applies to:
  • Microsoft Query for Windows, version 1.0
  • Microsoft Query for Windows 95, version 2.0


SYMPTOMS

In Microsoft Query, if you use the Create Database button in the ODBC Microsoft Access Setup dialog box to create a new database, the database still exists on your hard drive, even if you choose Cancel in the ODBC Microsoft Access Setup dialog box.


CAUSE

This behavior occurs because the new database you create using the Create Database dialog box is not removed when you cancel the Data Source setup procedure. Note that a new Data Source is not created when you cancel the driver setup dialog box for a given data source.


WORKAROUND

To work around this problem, you must delete the unwanted Microsoft Access database file (you can do this from File Manager or from the MS-DOS). Note that the Microsoft Access database file is created with a .MDB file extension by default.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.


MORE INFORMATION

When you create a Microsoft Access Database using the Create Database dialog box, you receive the following confirmation message


   Database <drive><path><database> successfully created. 
where <drive> and <path> are the drive and directory in which you create the new database, and <database> is the name you enter for the new database.

After you receive this message, the database is not removed by choosing Cancel in any of the subsequent dialog boxes.

Note that when you use the Microsoft Access 2.0 ODBC driver [Access 2.0 for MS Office (*.MDB)], you do not have the option to create a new database using the driver setup dialog box (ODBC Setup For Microsoft Access dialog box).


REFERENCES

For more information about the ODBC Microsoft Access Setup Dialog Box, choose the Search button in the ODBC Microsoft Access Driver Help and type:

setup dialog box

Additional query words: 5.00 5.00c

Keywords : xlquery
Version : 1.00 2.00
Platform : WINDOWS
Issue type :


Last Reviewed: September 20, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.


Send feedback to MSDN.Look here for MSDN Online resources.