[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 165
  • Last Modified:

Performance is slow

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
Startrac98
Asked:
Startrac98
  • 4
1 Solution
 
sdstuberCommented:
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
 
Startrac98Author Commented:
Sorry, Please move to MS Access 2007 zone.  Thank you
0
 
Dale FyeCommented:
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Startrac98Author Commented:
querying the linked tables
0
 
Startrac98Author Commented:
Resolved issue by re-designing flow
0
 
Startrac98Author Commented:
ok, please close
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now