Thanks, but I always make my selections go into a named temp file, so it is overwritten. I also have a routine that loops through all open tables and closes any temporary tables, which is regularly called by various routines.
However, are you saying that all queries are written to temp files in the users temp directory in XP? That could be a very useful piece of knowledge.
Do you know if this directory is stored on a server with a roaming profile or is it copied locally when the user logs on, and all temporary data is written there?
r
On Mon, 1 Dec 2003 10:13:19 EST, <[EMAIL PROTECTED]> wrote:
Robert,
If the edits are done to individual attributes by queries you might need to
delete the queries after the edits are made.
In other words kill table query1 ... kill table query2 and so on.
I found in Windows that you have a limit on the number of temporary files
(9999) after that the system locks up. If you have a recursive routine that
queries individual items in a table it will create a temporary file and place it in
the Documents and Settings \ Owner \ Local Settings \ Temp folder. After the
routine hangs up you have to exit to the destop then Open Windows Explorer. Go
to above described folder and look for files with a .tmp extension. IF you
have 9999 .tmp files then that is probably the problem.
Hope this helps.
Jon Gramm
--
Robert Crossley Agtrix P/L 9 Short St New Brighton 2483 Far Southern Queensland AUSTRALIA
153.549004 E 28.517344 S
P: 02 6680 1309 F: New Connection M: 0419 718 642 E: [EMAIL PROTECTED] W: www.agtrix.com W: www.wotzhere.com
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9371
