Y'all:

I need to create a temporary table from a query, add fields, use the data
for the particular user, then, when the user logs off, delete the table.

I've got the query (a make table query), and executed it, but I'm having
trouble finding the table to continue with adding fields, and the deletion
part.

Doesn't the make table query already to the append to the tabledefs or do I
need to do that manually? I've tried both ways.

I also have seen no example on how to delete a table from code.

TIA

Leah

I'm pretty sure a table created with a make-table should be listed in
TableDefs.  Pardon the question, but are you sure you're looking for the
table you've created, not the query?  (I do stupid things like that a lot.)
 If that's not the problem, maybe we could see some code.

Delete a table with DeleteObject.

HTH
        - Turtle

Hi Leah,

You need to issue a Refresh for the TableDefs collection to force the new
table to be appended to it.

Currentdb.tableDefs.Refresh

HTH
--
Dev Ashish    (Just my $.001)
The Access Web ( http://home.att.net/~dashish )
----

:Y'all:
:
:I need to create a temporary table from a query, add fields, use the data
:for the particular user, then, when the user logs off, delete the table.
:
:I've got the query (a make table query), and executed it, but I'm having
:trouble finding the table to continue with adding fields, and the deletion
:part.
:
:Doesn't the make table query already to the append to the tabledefs or do I
:need to do that manually? I've tried both ways.
:
:I also have seen no example on how to delete a table from code.
:
:TIA
:
:Leah
:
: