[AccessD] Write Conflict SQL and adp

Something else that you may want to try, David -- replace the stored
procedure with a view that does the same Select and then try to edit the
same row twice.
A.

On Mon, Jun 22, 2009 at 5:07 AM, Max Wanadoo <max.wanadoo at gmail.com> wrote:

> David, just a stab in the dark, but it sounds as if it hasn't written away
> the previous edit you made on the same machine.
>
> I often use me.dirty=false to force it to write edits away.
>
> Max
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
> Sent: 22 June 2009 09:46
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Write Conflict SQL and adp
>
> I have an SQL2005 BE and Access XP adp FE.
>
> The database is used to track stock for a number
> of locations.  Each stored procedure has a filter for location
>
> Most of the record sources are stored procedures
> that combine multiple tables (the extra tables
> are for sorting the records - for example a
> products table is joined to the inventory table
> so that the inventory can be sorted by product order).
>
> I have the unique tables set where I can, and the
>
> I am getting a "write conflict - This record has
> been changed by another user .  " error when I
> try to change a record a second time when it is displayed in a continuous
> form.
>
> I have tried Googling.  The main solution is to
> include a timestamp field in every table.  This I have done with no joy.
>
> Any thoughts on what I should look for?  Should I
> be looking at the SQL security setting for roles?
>
>
> Regards
>
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>