Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Virginia, USA
    Thanked 1 Time in 1 Post

    Temporary tables: Why and how? (2003)

    From time to time, I read in this forum about temporary tables. The comments in the threads I've looked at today via search all suggest that the participants know exactly what a temporary table is, why one would a temporary table, and how one builds such a table. Can someone point me to a "primer" on this topic? I have at hand one of those 2-inch thick books on Access, but I can't find a reference to temporary tables.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Sacramento, California, USA
    Thanked 1 Time in 1 Post

    Re: Temporary tables: Why and how? (2003)

    Strictly speaking, there is no such thing in Access. What is generally meant is a table that is created or populated on the fly with data that will not be retained but is only used for something like populating a report. There are temporary tables in SQL Server, but those are a different kind of thing entirely. When we talk about temporary tables in Access, we generally mean a table that is created using a MakeTable query, but it could also be a local table that is permanently in the database but the contents of which are cleared and replaced as needed.

Posting Permissions

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