You receive an error message when you click Next in a paged data view in FrontPage 2003 (821959)

The information in this article applies to:

Microsoft Office FrontPage 2003

SYMPTOMS

In Front Page 2003, when you browse to a page that contains a data view and then click Next, you may receive the following error message:

An error occurred while processing the data for this request. Contact the server administrator for more information.

CAUSE

This problem occurs because views that are created in Microsoft SQL do not have primary keys defined by default, and the paging function requires a primary key.

WORKAROUND

To work around this problem, make sure that your stored procedures or views in SQL contain primary keys.

STATUS

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

Modification Type:	Minor	Last Reviewed:	1/6/2006
Keywords:	kbDatabase kberrmsg kbprb KB821959 kbAudEndUser