Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
ACC97: Problems Adding Records to Replicated Database Using ASP
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.| Article ID | : | 165830 |
| Last Review | : | January 19, 2007 |
| Revision | : | 3.1 |
This article was previously published under Q165830
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
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'
Back to the top
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.
Back to the top
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.
Back to the top
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.
Back to the top
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.
Back to the top
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."
Back to the top
APPLIES TO
| • | Microsoft Access 97 Standard Edition |
Back to the top
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please
