ACC97: Problems Adding Records to Replicated Database Using ASP

Last reviewed: May 23, 1997
Article ID: Q165830
The information in this article applies to:
  • Microsoft Access 97

SYMPTOMS

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

If you export to ASP format a form based on a table in a replicated database, you cannot add new records using the ASP form.

If you look at an ODBC trace file, you see the error message:

   [Microsoft][ODBC Microsoft Access 97 Driver]
   You cannot modify the replication system object 's_Lineage'

CAUSE

The Microsoft Access 97 ODBC driver attempts to set values for the replication system columns, s_Generation, s_GUID and s_Lineage; Microsoft Access also adds one replication system column for each OLE Object field in your table. Microsoft Access does not allow you to set the values in those fields, so inserting the record fails.

RESOLUTION

Instead of using a table name in the RecordSource property of the form you are exporting to ASP format, set the RecordSource to the name of a Select query that contains all the fields in your table except the replication system columns.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 97. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

When you export a form to ASP format, the ASP file contains a SQL select statement that selects all the fields in the table. For example, if you base a form on the Shippers table, the SQL statement in the ASP file is:

   SELECT * from Shippers

This SQL statement selects all fields in the table, including the replication system columns.

When you base your form on a query that contains only the fields you want to update, the SQL statement in the ASP file names each field individually. For example:

   SELECT Shippers.ShipperID, Shippers.CompanyName, Shippers.Phone FROM
   Shippers

This SQL statement avoids the replication system columns in the table.

REFERENCES

For more information about ODBC trace files, start the ODBC Data Source Administrator, click the Tracing tab, and then click the Help button in the dialog box.

For more information about the replication system columns that are added to a table in a replicated database, search the Help Index for "replication fields."


Additional query words: insert update fail silent design master
Keywords : GnlOthr IntAsp RplGen
Version : 97
Platform : WINDOWS
Hardware : x86
Issue type : kbbug
Resolution Type : Info_Provided


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 23, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.