ACC1x: Unable to Import a SQL Server View

• 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.

REFERENCES

Microsoft Access "User's Guide," version 1.0, Chapter 4, "Importing, Exporting, and Attaching," pages 66-68

Keywords : kbusage OdbcOthr
Version : 1.0
Platform : WINDOWS
Issue type : kbbug