PC Review

Thread Tools Rate Thread

Optomistic Locking in adp

Posts: n/a
      23rd Jan 2004
I have an access project (.adp) running under Access Xp that has a form based on a view that includes a join between a tbale and it parent. The form displays fields from the parent and allows updates to the child row only.

If more than one user updtaes the child row I get a conflict error asking to 'save record', 'copy to clipboard', or 'drop changes'. However, the 'save record' option does not work, it just keeps redisplaying the same conflict error.

The child table is specified as the unique table and i have a resync command select * from view where childkey = ?.

This seems to work Ok for single table views but not for multi table views.

How to get the save record options to actually save the record ?

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
VB6 - Access ADP Database Custom Property / Or Read Line of Code In ADP Code Module WhatTha Microsoft Access VBA Modules 0 24th Jan 2006 04:26 PM
How to control ADP Connection when start ADP =?Utf-8?B?TmlraQ==?= Microsoft Access 0 11th Nov 2004 10:12 AM
2002 ADP versus 2003 ADP Carl Microsoft Access ADP SQL Server 3 12th Dec 2003 05:39 AM
Re: ADP routine fails in ADP. Vadim Rapp Microsoft Access ADP SQL Server 0 7th Jul 2003 06:19 PM
Re: ADP routine fails in ADP. BJ Freeman Microsoft Access ADP SQL Server 0 7th Jul 2003 04:01 PM




All times are GMT +1. The time now is 05:24 AM.