I will be using Access for the database.
Ouch. One word of caution: "simultaneous multi-user access" and MS-Access don't go well together. MS-Access if fine as long as you stick to single user. Try to get a more suitable database, for example PostGres, MS-SQL Server, or even MySQL. MS-Access is known to regularily cause data corruption, with simultaneous multi-user edits.

As for your approach... IMO you can have live updates on your data, as long as the user wasn't actually in the middle of editing it. At the least, you do need a central locking mechanism, making sure only one user can edit a particular field, or a particular record, at a time.

Less intrusive would indeed be a simple indicator, that might look a bit like a colored LED, indicating whether the data shown is up to date (green) or stale (red).

In reply to Re^2: Database Realtime by bart
in thread Database Realtime by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.