Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
ACC2000: How to Create and Use Temporary Tables with Access Client Server
Article ID: 232379 - View products that this article applies to.
This article was previously published under Q232379
Advanced: Requires expert coding, interoperability, and multiuser skills.
This article applies only to a Microsoft Access project (.adp).
You can create temporary tables in both SQL Server and the Microsoft Data Engine (MSDE) using Access Client/Server. Even though you cannot see the tables in the Table pane of the Database window, temporary tables are available for use through stored procedures and other means.
When you create a temporary table in a database hosted by the MSDE or SQL Server, it is stored in the tempdb database. An Access project will connect to only one back-end database at a time (generally, a user database).
Because temporary tables and user tables are stored in different databases, Access Client/Server will not display both. Temporary tables are accessible from a user database through stored procedures and triggers, however.
The example below demonstrates the following:
To create a temporary table
To INSERT and SELECT records from a temporary table
For more information about temporary objects, refer to SQL Server 7.0 Books Online, which is available for download from the following Microsoft Web site: