Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2006
    Posts
    157

    Question Unanswered: table on the front end

    hi everyone,

    what consequences am i looking at if i placed a table on the front end?


    just a temporary table to hold some temporary values
    to pretty much function like global variables would
    (i've had some issues with global variables)

    ty
    Only quitters quit!

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Should be no problem.
    Paul

  3. #3
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    I would recommend it. If the purpose of the table is more saving user responses and not data collection then I consider it part of the code. Therefore I put it in the frontend. Putting it in the backend will be more difficult since you will have to keep track of each user's response or live with conflicts.

  4. #4
    Join Date
    Oct 2004
    Location
    Melbourne, Australia
    Posts
    201
    I would take the matter even further than friend DCKunkle has suggested. A database is an architectural construct of tables and relationships. It fails if anything is missing. I would suggest that the main backend be retained ONLY for the database as viewed in this way. Temporary tables used for manipulation should be placed in the FE if their use is on a per user basis or in an alternate backend if shared. This latter idea protects the main database from any accidental damage if a collaborative user activity goes badly wrong.
    I habitually use multiple front and backends in this way, including a sandpit where users gaining Access experience can muck about with queries and suchlike which might otherwise damage the operation of forms and reports if accidentally modified.

  5. #5
    Join Date
    Apr 2006
    Posts
    157

    Smile

    thanks,

    i really appreciate valuable response from you guys,

    initially, i just wanted some encouragement on this,

    but you've all been very informative

    many thanks
    Only quitters quit!

Posting Permissions

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