Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mistux
Yak Posting Veteran
90 Posts |
 Posted - 2006-05-08 : 17:27:05
|
| I am getting the following error: Write Conflict--This record has been changed by another user since you started editing it....I think i know why, but I am sot sure what to do about it.I have a main form with a sub form, each is based on a stored procedure with only one table in it (not the same table) and only one parameter.When I make a change to anythign in the subform I update the main form's "last changed date" field then when I hit save on the main form I get the error.How do I resolve this?I am using Access 2002 SP 3 with an .ADP not .MDB and MS SQL Server 2000.MichaelFor all your DNC needs for your CNC machines. www.mis-group.com |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-09 : 01:30:51
|
| instead of updating the main form after updating the subform, refresh the main formwhen i was doing access (long long time ago), i don't make changes on the main form, i only use that for viewing, any changes i make on the subforms, then refresh the main form when anything is done on the subform, this way referencing will not be brokenHTH--------------------keeping it simple... |
 |
|
|
|
|
|
Write Error