Solved

Performance is slow

Posted on 2011-09-19
9
157 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:Startrac98
  • 4
9 Comments
 
LVL 73

Expert Comment

by:sdstuber
ID: 36561849
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.


0
 

Author Comment

by:Startrac98
ID: 36561861
Sorry, Please move to MS Access 2007 zone.  Thank you
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 36561905
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?
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Accepted Solution

by:
Startrac98 earned 0 total points
ID: 36561925
querying the linked tables
0
 

Author Closing Comment

by:Startrac98
ID: 37035355
Resolved issue by re-designing flow
0
 

Author Comment

by:Startrac98
ID: 37011375
ok, please close
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question