Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Unrelated Rows in a Subreport or a Subform Are Returned When the Linkmaster Property or the Linkchild Property Uses Decimal Fields

Unrelated Rows in a Subreport or a Subform Are Returned When the Linkmaster Property or the Linkchild Property Uses Decimal Fields

View products that this article applies to.

This article was previously published under Q319547
This article applies to a Microsoft Access database (.mdb) and a Microsoft Access project (.adp).

Moderate: Requires basic macro, coding, and interoperability skills.

↑ Back to the top

Symptoms

Unrelated rows in a subreport or a subform may be returned when the LinkMaster property or the LinkChild property uses fields of the Decimal data type and the table is linked through ODBC.

↑ Back to the top

Cause

This problem may occur if the decimal separator is not set to use a period (.) in the Regional Options Control Panel.

↑ Back to the top

Resolution

This problem has been fixed in the latest edition of the Jet Service Pack. For additional information about how to obtain the latest version of the Jet 4.0 database engine, click the following article number to view the article in the Microsoft Knowledge Base:
239114� How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem has been fixed in the latest edition of the Jet Service Pack.

↑ Back to the top

Keywords: KB319547, kbfix, kbbug

↑ Back to the top

Article Info
Article ID : 319547
Revision : 3
Created on : 11/13/2003
Published on : 11/13/2003
Exists online : False
Views : 244