Access 2002 exits when you create or try to modify an in-line function when the Access 2002 project is connected to a SQL Server 2005 database (917415)

SYMPTOMS

Consider the following scenario. A Microsoft Access 2002 project is connected to a Microsoft SQL Server 2005 database. You create a new in-line function or try to modify an existing in-line function in the Access 2002 project. In this scenario, Access 2002 exits, and you receive an error message that is similar to the following:

Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.

When you view the details of the error report, you notice that the error occurred in the Msaccess.exe process.

WORKAROUND

To work around this problem, click one of the following commands on the Insert menu when you want to create a new function:

Create Text Scalar Function
Create Text Table-Valued Function

Another method to work around this problem is to create a new query in the SQL Server Management Studio. Use the Design Query in Editor command. To do this, follow these steps:

On the File menu, click New, and then click Query with Current Connection.
On the Query menu, click Design Query in Editor.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about how to design queries and views in SQL Server 2005, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/en-US/library/ms177431(SQL.90).aspx