SORRY; THIS SIZE LIMIT IS ONLY PRESENT IN MDB; THIS IS NOT A LIMITATION IN MDB On May 11, 8:56 am, RogerManiccia@ebs <rmaniccia_discussi...@technet.com> wrote: Peter, Sometimes when this has happen to me, I first thing I check is the size of the database. MS Access has a 2GIG size limitation. Even if the issue is not the size limitation, I would be inclined to compact

This query runs for about 7 seconds, then pops an error dialog: "Invalid Argument" What's got me stumped is how long it runs. Typically when I mess something up it gets caught on the syntax scan or it bombs almost immediately after starting to run. Visual representation at: http://www.flickr.com/photo_zoom.gne?id=493642965&size=o SQL for the main ("...Moody2") Query: -----------