Recordset- Tempory Files On Client Machine

[TURNERMICH]

I am running an access2000 program on a server.
There are several Temporary files needed. I need to have these files on the remote users machine., to keep them common to each user.
---------------

Set ff1 = db.OpenRecordset("file1", DB_OPEN_TABLE)
Set dbtemp = OpenDatabase("c:\accesstemp\Temp.mdb&quot
Set ff2 = dbtemp.OpenRecordset("temp1", DB_OPEN_TABLE)

ie. The ff2 file is created from the ff1 recordset.

Then.... I need...
List99.RowSource = "SELECT [Temp1].[Tdata1], [Temp1].[Rec], [Temp1].[Tdata2] FROM [Temp1]"


How do i refer to the temp file in the SELECT statement.

I need to keep the current mdb file open, but also have the c:\accesstemp\temp.mdb open., and use temp1 in this file as the select.


Appreciate some help.