<div>
can you post some code? or at least some trace information about where performance lag is coming from?<br />
<br />
querying 1000 records should be sub second for most operations.<br />
<br />
<br />

</div>


can you post some code? or at least some trace information about where performance lag is coming from?

querying 1000 records should be sub second for most operations.




<div>
Sorry, Please move to MS Access 2007 zone. &nbsp;Thank you
</div>


Sorry, Please move to MS Access 2007 zone.  Thank you

<div>
How are you accessing the information in your backend database?<br />
<br />
Linked tables<br />
ADO<br />
<br />
If linked tables, are use querying the linked table, or using pass-thru queries?
</div>


How are you accessing the information in your backend database?

Linked tables
ADO

If linked tables, are use querying the linked table, or using pass-thru queries?

<div>
Resolved issue by re-designing flow
</div>


<div>
<div class="content wysiwyg-content">
small database (1000 Records) that takes 15 seconds to open form. &nbsp;Form has sub forms based on query and a subform from that form. &nbsp;Data is in a separate database on a network server. &nbsp;Looking to improve performance. &nbsp;need suggestions. Thanks.
</div>
</div>


small database (1000 Records) that takes 15 seconds to open form.  Form has sub forms based on query and a subform from that form.  Data is in a separate database on a network server.  Looking to improve performance.  need suggestions. Thanks.

Performance is slow

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.