Temporary table in Access database


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Temporary table in Access database

  1. #1
    Marcus Guest

    Temporary table in Access database


    How do I create a clone of a table in an Access database at runtime, I know
    I can use the CREATE TABLE command but I also
    need to clone the contents of the table.

    Thanks for any help
    Marcus


  2. #2
    Larry Muller Guest

    Re: Temporary table in Access database


    "Marcus" <marcus@motionworx.se> wrote:
    >
    >How do I create a clone of a table in an Access database at runtime, I know
    >I can use the CREATE TABLE command but I also
    >need to clone the contents of the table.
    >
    >Thanks for any help
    >Marcus
    > Us


    Use the create table or (MakeTable type query) and just create a query that
    selects all of the fields in the table and >0 in the ID field criteria.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center