Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2008
    Location
    All over, Now in Missouri
    Posts
    73

    Unanswered: Saving a file before deleting

    I have a personnel table with all the details and 2 subforms.

    When a person leaves I would like to append their record to a history_personnel table, then have their record deleted.

    What direction should I go to get this done?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    The table is in Access right? Not SQL Server or some other service based RDBMS?

    Are you using linked tables, local tables or disconnected tables?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Apr 2008
    Location
    All over, Now in Missouri
    Posts
    73

    Here is the layout

    This is an Access Database, structure is frontend (forms) with linked tables (Backend). Database is located on a server that acts as a shared file drive.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I wouldn't do it tbh. Filling in their Date of Departure field should be enough.

    Otherwise, to make the archive complete, you'd have to have history_* tables for everything related to personnel and move that data as well, with a string of APPEND and DELETE queries executed in the right order.

    Sounds like you're making things hard for yourself.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •