[AccessD] Deleting record

Gary Kjos garykjos at gmail.com
Thu Apr 8 15:36:23 CDT 2010


Once again sending to the list gets the problem solved. It's the magic
of the list!

<Grin>

Glad you got it fixed Debbie.

GK

On Thu, Apr 8, 2010 at 3:28 PM, Debbie <delam at zyterra.com> wrote:
> After days of beating my head on this one, I discovered the answer
> after asking the question here. It turns out the culprit was some
> error handling code to get rid of records that could be saved, but
> were not complete enough to be good data.
>
> Debbie
>
> Sent from my iPhone
>
> On Apr 8, 2010, at 1:33 PM, Debbie <delam at zyterra.com> wrote:
>
>> I have a database that is deleting a new record when another user
>> enters the same type of new record. If the first user exits the form
>> where the record was created, it will not get deleted, but if they are
>> both creating records, the second is the only one to remain and save.
>>
>> I thought it may be a conflict in trying to save, so I tried multiple
>> methods to make sure the record was saved before user 2 started their
>> record. I have even created a minimal record before even opening the
>> form and then opening the new record I just created, but the delete
>> still happens.
>>
>> We are only getting this while running the app on a terminal services
>> app called Netilla and both users are using the same FE. This is on
>> 2007 and most are using runtime, though a test with the full Access
>> installation had the same problem.
>>
>> Debbie
>>
>> Sent from my iPhone
>> --
>> 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
>



-- 
Gary Kjos
garykjos at gmail.com



More information about the AccessD mailing list