Using a temporary table....TempDB?

[Jay Bukstein]

I have a database using MSSQL 2000 as the back end and
Access as the front.. I need to create and use a
temporary table. I want to access from VBA code TEMPDB,
Can this be done, and if so Any Idea's