ACC2000: Error Message When You Change the Properties on a Replicated Table That Has a Decimal Column

When you try to save a change that you made in Design view of a table, you may receive the following error message: When you click OK, you receive the following error message:

You receive these error messages when all of the following conditions are true:

• You are working in a Jet SQL replica.
  
  -and-
• There is at least one decimal column in the table that you are changing.
  
  -and-
• You change a property for any column, for example the ValidationText property.

To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.

If you click Yes when Access asks if you want to save the design of the table, you receive the error messages mentioned in the "Symptoms" section of this article again.

If you click No, when you open the table again, you find that Access saved the properties that you changed anyway.

Steps to Reproduce Behavior

1. Open the sample database Northwind.mdb.
2. Create the following new table:

      Table: tblMyTest
      ----------------------
      Field Name: DecimalCol
      Data Type: Decimal
      Length: 13
      Precision: 28
      Scale: 14
   					

3. Create a Merge publication and specify that some subscribers will be Jet 4.0 databases. Select the tblMyTest table as the only article.
4. Create a global Jet subscription and name it MyTest.mdb.
5. Push the publication to the subscription.
6. Run the Merge Agent if it has not already run.
7. Open the MyTest.mdb file in Access 2000.
8. Open the tblMyTest table in Design view.
9. In any column, change the ValidationText property to Testing.
   
   NOTE: To reproduce this error, you can change any property.
10. Save the table. Note that you receive the error messages mentioned in the "Symptoms" section of this article.