Results 1 to 6 of 6
  1. #1
    Roncc is offline Advanced Beginner
    Windows 10 Access 2010 32bit
    Join Date
    Dec 2017
    Posts
    85

    Temporary table in the front end appending to a table in the back end


    I am a complete novice when it comes to server issues but I have a project I need some assistance with. My question is: Can I safely use a temporary table on the front end of the project which will be appended to a permanent table on the back end after which the records in the temporary table will be purged of the records with a front end delete query. The algorithm will look like this: IF I want to set up an appointment with a client I create the record in the temporary table tempappt, entering the data with a form whose data source is the table tempappt. Once the user completes the record he will click a button to save it at which time the code will initiate to run a query to append the table tempappt (on the front end) to the table appt (the permanent table) on the back end. After the append query runs a delete query (on the front end) will run which will delete the single record in the table tempappt. My concern is that it may get balled up if I have multiple users.

    Thanks for all the help, you guys/gals are great.

    Ron Cheshier

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Should work, as long as the temp table is in the front end (and each user has their own copy).
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Roncc is offline Advanced Beginner
    Windows 10 Access 2010 32bit
    Join Date
    Dec 2017
    Posts
    85
    Thanks Paul. I not that familiar with how the front end/back end separation works. When you say "each user has their on copy" do you mean a copy on their own computer like on their C drive or as part of the front end set up where the temporary table location is defined by default when each user logs in to the program? I'm trying to clarify how "front end" works. Does it mean that the tables are placed on the server directory (i.e. a Z drive) on the back end while forms, reports, and queries reside on the local drives (i.e. C drive) of each user?

    Thanks for all the help, I really appreciate it.

    Ron

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    In a normal setup, the backend with tables only is located on a server. Each user has a copy of the front end, which has all the forms, reports, etc. the temporary table you describe would be in the front end. Some developers use a "side end", a second db on the user's computer with temp tables. That avoids bloat in the front end. I've never bothered with that.

    You mention Z drive; most of us avoid linking through mapped drives, to avoid issues if the drive isn't mapped. Use a UNC path.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Roncc is offline Advanced Beginner
    Windows 10 Access 2010 32bit
    Join Date
    Dec 2017
    Posts
    85
    Thank you so much. You've been very helpful.

    Ron

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problem Ron.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Table Relationships... Front vs. Back
    By Kaloyanides in forum Access
    Replies: 8
    Last Post: 11-30-2017, 04:22 PM
  2. Replies: 12
    Last Post: 12-25-2015, 03:25 PM
  3. Replies: 1
    Last Post: 04-10-2014, 12:17 PM
  4. Replies: 2
    Last Post: 12-05-2013, 12:09 PM
  5. Update Master Table with Temporary Table
    By kagoodwin13 in forum Programming
    Replies: 2
    Last Post: 10-15-2013, 11:59 AM

Tags for this Thread

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