calling stored procedures gives write conflict

[lgkf]

I've done some MySQL work (sorry no postgre - but I hear it is a good DB). After reading your post I started thinking of row locking as you said the Access Form is taking data from the your DB for this record, and maybe the reason it is giving you write conflicts as you already have the row locked by your form.

The magic word - you named it: locks
a simple:
Me.RecordLocks = false
just before calling the sp did the trick
- but no more value changes by vba can be made beyond this - what is not really a problem: just what I wanted.

I hope this helps, let me know if I'm way off base as I was kind of confused reading your post

no confusion was intended - maybe access confused me so much to write confusing postings