• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Protecting integrity of data records

Explorer ,
Jun 27, 2013 Jun 27, 2013

Copy link to clipboard

Copied

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.

Views

698

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Engaged ,
Jun 27, 2013 Jun 27, 2013

Copy link to clipboard

Copied

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Jun 27, 2013 Jun 27, 2013

Copy link to clipboard

Copied

Thank you for the reply.  I was fearing that the question would go unanswered. 

I appreciate what you are saying, but I am dealing with an existing database that is used by multiple web programs.  At the present time I am stuck with Access because of this.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Engaged ,
Jun 27, 2013 Jun 27, 2013

Copy link to clipboard

Copied

LATEST

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!

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation