Results 1 to 6 of 6

Thread: Cloning tables

  1. #1
    Join Date
    Apr 2002
    Posts
    168

    Unanswered: Cloning tables

    I am setting up a database that will be used by multi-users using linked-tables. The problem I am having is there a couple of different users that can modify tables. However, there is one (user A) that is above other users. So, let's say user B changes the values in a table and logout, and then user A login and does not like the changes user B made, then user A can restore all values back to the original (before user B changes). I am not sure how to this. Should I just create 2 copies of the same table, so kind of mirroring ? Then, how do I keep track of changes made, do I need to create a log table ?


    Thanks

  2. #2
    Join Date
    May 2002
    Posts
    37
    A.
    Sounds like you need to have them establish a standard that will be adhered to.
    Too many changes/suggestions by individuals not familiar with database design will surely lead to your db not being normalized.

    B.
    If a standard cannto be determined, you may want to develop a switchboard with a couple of forms (not allowing the users to view/modify the tables). From that point user A could have a custom form, and user B could have a custom form.

    (I would strongly suggest the "A" over "B". Eventually "B" will become a nightmare of "I don't like this, I want this here, that there". Eventually it will drive you crazy.)

  3. #3
    Join Date
    Apr 2002
    Posts
    168
    Thanks

    In my case, it's not so much about the database design that is changed, but the value of the fields itself. So, basically, the lower-level users can change the data. However, in the end, those changes must be approved by higher-level users. So, maybe, when higher-level users login, he/she will see the changes made and if he/she agrees, then those changes will be copied to the original tables. Otherwise, it will be disregarded. Any idea about how I should go with this ? I was thinking of creating a log-tables that record all changes made by lower-level users, but still not sure how.

  4. #4
    Join Date
    May 2002
    Posts
    37
    OK, now I understand.

    I will post an example this evening.

  5. #5
    Join Date
    Apr 2002
    Posts
    168
    Thanks.

    My other concers are not just when lower-level changes the value, but also when they delete or add a record.

  6. #6
    Join Date
    May 2002
    Posts
    37
    Sorry for the delay!
    It's a bit sloppy but I am sure you can clean it up.
    Attached Files Attached Files

Posting Permissions

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