I have a Front End and Back End, both of which are on the network in
the same directory. The Front End contains all the temp tables used.

Questions:
1. Should TempTables be in FE, BE, separate .MDB?
2. Should they be deleted immediately? Or is it appropriate to let
them be written over the next time it's used?
3. Should the use of TempTables be avoided if possible, or does it
not make a difference?
4. Do TempTables affect performance in any way?
5. I have found that performance is better with the FE located on the
network as opposed to locally. It seems like this shouldn't be the
case. Any ideas?

Thanks!
Diane

RE/
Dunno from "best", but I'd say:

1) Temp tables should be in a separate .MDB. I put mine in C:\Temp as
AppNameTemp.mdb.

2) Personally, I embrace temp tables. They make things like modal screens a
lot easier to manage and, in the case of large dropdown lists, can improve
response time.


-----------------------
PeteCresswell