<div>
<div class="content wysiwyg-content">
I have created a dynamic query which when executed against the database it returns a message stating &quot;Query to complex&quot;<br />
<br />
what is the maximum number of characters can a query contain.<br />
<br />
by the way my query contains 89,999 characters 
</div>
</div>


I have created a dynamic query which when executed against the database it returns a message stating "Query to complex"

what is the maximum number of characters can a query contain.

by the way my query contains 89,999 characters 

What is the maximum number of characters can be in a select union query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.