Since changing all of my macros to code in my database it seems that the db has slowed down and leaves me with loads of temp files in my temp directory. The files are in the format 'wiz123.tmp', where the 123 can be any series of numbers and I get about 50 of them if I do any work on the db.
It only started after I wrote the code, I,ve compiled and checked it myself word for word but can't see anything wrong.
I was under the impression that code was faster than macros and in specific processes it seems to be, but the actual general running of the db is slower (screens take longer to clear and forms sometimes open like a slow blind being lowered)
Any thoughts anyone?