Skip navigation
NVL-Tom
Currently Being Moderated

Protecting integrity of data records

Jun 27, 2013 7:16 AM

I have a MS Access database that is accessed over the web via Coldfusion pages developed in Dreamweaver.  A big portion of activities concerning the database records is the update of fields within the records to reflect activities performed.  The activities are frequent and any record could be subject to updating multiple time each day by any one of 5 staff members.  Obviously data integrity is of utmost priority, and I am looking for the means to ensure that if a record is open that another staff can not perform an update until the other party exits the open record.  

 

With my intermediate skills, I was thinking of establishing a status check off box and that upon entering the lead the box would be checked and the record updated.  In this was the underlying page page displaying available (hyperlinked) records could reflect the status of the record in accordance with a 0 or 1 being present in the "STATUS" field.  But I was hoping for a more elegant solution.

 

Any advice that you can lend would be appreciated.

 
Replies
  • Currently Being Moderated
    Jun 27, 2013 10:48 AM   in reply to NVL-Tom

    If data integrity is one of your top five objectives, stop using Microsoft Access for a web database immediately. Move to something that is up to the task such as SQL Server or MySQL. This is especially true when you are concerned about things like record locking, etc.

     

    Access is great for tracking your baseball card collection, but multi-user applications over the web are a disaster waiting to happen.

     
    |
    Mark as:
  • Currently Being Moderated
    Jun 27, 2013 8:38 PM   in reply to NVL-Tom

    I agreed with tclaremont's suggestion about moving to enterprise level database system. I also understand your situation because it happened to me before.

     

    I'm not an expert in Access, but adding STATUS field would do the job.

     

    Good luck!

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points