<p>What are the maximum allowed number of columns in a query in access 2003?</p>

As a general rule, if you ever find yourself asking a question about the maximum hardcoded limit of a technology, it's time to step back and verify that you're taking the right approach.  Perhaps a query against access that's pulling in hundreds or thousands of columns isn't the right approach.