Solved

Performance is slow

Posted on 2011-09-19
9
160 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
9 Comments
 
LVL 74

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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Suggested Solutions

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

739 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