Results 1 to 4 of 4
  1. #1
    Nelson12 is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2010
    Location
    Philadelphia
    Posts
    12

    Need to use access for this, need some help

    Hello all!



    I hope this is not to difficult to solve, but I have an idea on this but I don't know if its wrong or right or if there is a better way I can do this.

    I have an access 2007 server with 10 people connected to it constantly updating it daily. Everyone has a front end on their laptops and I am the only one who can edit and change the back end. Everyone uses a form to input data and and that's it, they can only view the table that the data is entered.

    But we have a data that must be approve before it can be entered into the database. I have figured i can make a separate database for this. This data is written up on white boards and is posted on he share server and looked at and it gone through 3 levels or editing and approval. It is then entered into the database. After a few weeks we erase these white boards and start over. So i cant use my existing database to create relationships with this because the data cannot be inside the database yet until approved.

    I am looking for a way to solve the constant movement of everyone in the office to have to go up to the white boards to show the status of that data. And I want to use access to be able to do the same job as the white boards that shown the status of each item needing approval.

    Any input would be greatly appreciated, thank you.

  2. #2
    Guus2005's Avatar
    Guus2005 is offline Carbon based thingy
    Windows 7 Access 2003
    Join Date
    Jan 2010
    Location
    the netherlands
    Posts
    42
    Quote Originally Posted by Nelson12 View Post
    But we have a data that must be approve before it can be entered into the database. I have figured i can make a separate database for this. This data is written up on white boards and is posted on he share server and looked at and it gone through 3 levels or editing and approval. It is then entered into the database. After a few weeks we erase these white boards and start over. So i cant use my existing database to create relationships with this because the data cannot be inside the database yet until approved.
    You can create relationships. To suppress the records that are not approved create a table "tblApproved" to store each RecordId which was approved.
    When you create a query to show approved records, you only have to link the table to the tblApproved table.

    HTH

  3. #3
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    separate DBs, or separate tables is NOT the way to go......better to add a field to your main table for 'Approved' (or 'Status') - maybe a checkbox or maybe a textbox.... you can enter data and define it as 'Pending Approval'....this will allow you to present it forms, reports with that caveat....but once it is approved you only need to change it status to 'Approved' or maybe to 'Canceled' or whatever...

    in the long run it is simple, plus it gives you a history of past data - and if ever anything is Canceled but then reversed back to Pending or Approved it is really simple to accommodate that....

  4. #4
    Guus2005's Avatar
    Guus2005 is offline Carbon based thingy
    Windows 7 Access 2003
    Join Date
    Jan 2010
    Location
    the netherlands
    Posts
    42
    Quote Originally Posted by NTC View Post
    separate DBs, or separate tables is NOT the way to go......better to add a field to your main table for 'Approved' (or 'Status') - maybe a checkbox or maybe a textbox.... you can enter data and define it as 'Pending Approval'....this will allow you to present it forms, reports with that caveat....but once it is approved you only need to change it status to 'Approved' or maybe to 'Canceled' or whatever...

    in the long run it is simple, plus it gives you a history of past data - and if ever anything is Canceled but then reversed back to Pending or Approved it is really simple to accommodate that....
    That is a matter of opinion. Your solution is also possible. I agree that creating a database for this purpose is not advisable.

    Enjoy!

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums