Reports opened very slow

  • Thread starter Thread starter Roy Goldhammer
  • Start date Start date
R

Roy Goldhammer

Hello there

I have huge access application

In the application i have many reports (60 approx). all of them bound to
local tables and suddenly go on realy slow. (22 seconds) even when i open
them for design.

what can cause this thing to happen?

any help would be useful
 
When was the last time you compacted the database? Is the database split
into a front-end/back-end? Do you have a network admin to check your network
connection if part or all of the database resides on a network drive? Are
you opening the database into design view while other users could be using
the database? Not an issue if you are using a split database.
 
Whee GVaught

All the things i have on my application

In fact the problem i said about loading report on design view was on my
computer that in that time wasn't connected to the database

All of my reports are bound to local tables and have no connection with the
database and it still work realy slow. even 22 seconds, I also using access
2000 which have automaticly compact on close

But what i do have is only one MDB with 60 reports at least. it's size after
compact is 17mb

Maybe this can cause the problem

Can you help me on it?
 
Back
Top