Append and Delete Records in Table

[data808]

I have an append and delete system set up in Access to archive the records in another table. Was just wondering if I am able to do this while users are in the frontend updating records. I will be doing this for old records (2014-2015) and probably won't have users looking at any of these records but was just wondering if this was safe? Should I wait till everyone is logged off to do this type of archive? Thanks.

[Welshgasman]

Yes, that would be a good idea.

[Micron]

If there are no record locks involved at the time then it won't matter. If 2 users attempt to modify the same record or separate records that are contained within the same page, then the second user who accesses that page could get a conflict error - depends on the record level locking option that you have set. So research on record locking in Access might be a good idea. Another option would be for you to open the db exclusively, then no one else can interfere - but of course, this requires that no one else has a connection to the be at that time. Usually it's better to flag records so that they're "archived" rather than actually moving them to some archive table if that's what you're doing. Regardless, even that approach would require that no one has already put a lock on those records, which as you stated, is unlikely. Access will warn the user who last modifies a record and attempts to save if 2 or more have been editing it at the same time.