Within SQL Server, temporary tables are stored in the Temporary Tables folder of the tempdb database. How are transactions used? Transactions allow you to group SQL commands into a single unit.

I'm looking to make an access report that is dependent on data from a remote SQL Server. ... Take that recordset and use it to create a new table (a temporary one) in the local Access database.<BR ...