Reports fail in Access 2003 runtime but not in full Access

[DJJ]

I have a mde file that is distributed amongst a small group of users. All
of a sudden some reports based on queries will not run in access 2003
runtime. They will work using full versions of access 2003. This just
started happening for no reason.

I have tried compacting and repairing and making a new mde. Repairing the
runtime access install and reattaching data through odbc to the SQLserver 2K
database but the failures still persist. I've also rebooted the server and
routers so it does not seem to be a network problem. Any thoughts???

 

[tkelley via AccessMonster.com]

Are you by chance calling the report by opening it in design mode and
changing filter properties? I've encountered that kind of thing in my
predecessors' work. When I tried to deploy an mde in Runtime, it didn't work,
because it will not utilize the design environment.