[AccessD] Deleting record

Debbie delam at zyterra.com
Thu Apr 8 15:28:12 CDT 2010


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
>



More information about the AccessD mailing list