>I mentioned this before, but it started to become a real big problem for me, so I'll post this lest anyone else have this problem.
>
>I've found and fixed the cause of all my Invalid Seek Offsets under NT. They're caused by macros in paths and other strings, almost anything outside of SQL (which seems to have no problem with macros, fortunately). NT sometimes does not like macros, for whatever reason, sometimes it reads them successfully, but occasionally it doesn't "understand" them. It does not error on the macro itself, but does not pick up the value the macro references. Replacing macro strings with parentheses works almost everywhere to fix the problem.

David Fluker contributed an excellent FAQ a few months back on the topic of macro expansion vs. named expressions and EVAL(). FAQ #7841. I highly recommend that everyone who hasn't read it do so, even if you think you know what is oing on, and the difference between all these ways of doing something.