Replace <DSNName> with the name of your ODBC Data Source for the SQL Server database, replace <ServerName> with the name of your SQL Server, replace <UserName> with the logon name of a valid SQL Server user, and replace <Password> with a valid logon password.
On the Query menu, click Run. Note that the query's results are displayed and no error is generated.
Microsoft has confirmed this to be a problem in Microsoft Access 97. Thisproblem no longer occurs in the Microsoft Jet Database Engine version 3.51,which is available from the Microsoft Download Center.
For information on how to obtain Microsoft Jet Database 3.51, please seethe following article in the Microsoft Knowledge Base:
172733 ACC97: Updated Version of Microsoft Jet 3.5 Available for Download
Steps to Reproduce Problem
The following example uses the sample database Northwind.mdb because itcontains local tables with enforced relationships, which satisfies two ofthe four requirements to produce the error.
This example assumes that you have linked the dbo.authors anddbo.titleauthor tables to your database from the SQL Server sampledatabase called Pubs.
WARNING: Following these steps will cause an invalid page fault on yourcomputer. Make sure you save and close any open work on your computerbefore following these steps.
Open the sample database Northwind.mdb.
Create the following new query based on the dbo_authors and dbo_titleauthor tables: