Microsoft KB Archive/98674

{|
 * width="100%"|

ACC1x: Unable to Import a SQL Server View

 * }

Q98674

-

The information in this article applies to:


 * Microsoft Access 1.0

-

SYMPTOMS
You can attach a SQL Server view. If you attempt to import this view, you receive the following error message:

Internal database error (-1603)

STATUS
Microsoft has confirmed this to be a problem in Microsoft Access version 1.0. This problem no longer occurs in Microsoft Access version 1.1.

MORE INFORMATION
A SQL Server view is similar to a dynaset. It is the result of running an SQL query.

Steps to Reproduce Problem

 * 1) Use another application, such as Microsoft Excel Q+E, to create and save a SQL Server view.
 * 2) Start Microsoft Access and open a database.
 * 3) From the File menu, choose Import.
 * 4) Select SQL Database as the Data Source.
 * 5) Select the Data Source you want to import.
 * 6) Log on to the SQL Server by entering your password and choosing OK.
 * 7) Choose the SQL Server view to import from the Import Tables dialog window.