PC Review


Reply
Thread Tools Rate Thread

Optomistic Locking in adp

 
 
=?Utf-8?B?ZGF2ZWg=?=
Guest
Posts: n/a
 
      23rd Jan 2004
Hi
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 ?

Regards
Dave
 
Reply With Quote
 
 
 
Reply

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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:19 PM.