"Elizabeta" <anonymous@discussions.microsoft.com> wrote in message
news:87868334-D4DC-4DFE-BF56-8E691E391E02@microsoft.com...
> I have an application that should archive records, meaning that I want to
move entire record into another table, serving as archive.
>
> First, I copy the required record into the archive table;
> Then, I delete from the main table.
>
> I do it in one stored procedure.
>
> I use Begin Trans,
> after writing into archive table I ask for errors.
> if @@error == 0 then
> begin
> delete from maintable
> if @@error == 0
> commit trans
> else
> rollback trans
> end.
>
> The front end is in MSAccess 2000, with ADO objects activating this Stored
Procedure.
>
> This works in most of the cases, but sometimes it happens that I have
records deleted and not archived.
>
> Probably checking @@error is unable to find out if the record is correctly
written on safe place.
>
> Does anybody know why is this happening, is it maybe MSaccess problem, or
am I doing something wrong.
>
> How are you pepole, actually, doing archiving?
>
> Thank you in advance.