do unused reports slow down database performance?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I'm developing an Access database that has grown very big (8 MB front-end even as an .MDE, back-end up to 6 MB). We are planning to eventually migrate to a web-based SQL server system, but that process will take some time (at least a year). In the meantime, I'm looking at ways to improve database performance. Most users don't use the database for anything other than data entry- would it help performance for them if I developed a "light" version of the database, excluding reports and their supporting modules/queries? Thanks for any advice.
 
I´ve devoloped a database tha we use daily on 15 machines
in a network. The database i today approx 30MB. No
problems with the speed.
Some tip:With a MDE file it´s much slower, just locate a
MDB file on a networkdrive and everyone runs that one.
Program as much as possible with VB-code. I have no
macros onely code. Every form based on a query and so on.
6 or 8 MB shouldn´t be any problem.

-----Original Message-----
Hi,
I'm developing an Access database that has grown very
Click to expand...
big (8 MB front-end even as an .MDE, back-end up to 6
MB). We are planning to eventually migrate to a web-
based SQL server system, but that process will take some
time (at least a year). In the meantime, I'm looking at
ways to improve database performance. Most users don't
use the database for anything other than data entry-
would it help performance for them if I developed
a "light" version of the database, excluding reports and
their supporting modules/queries? Thanks for any advice.
 
Thanks for the tip

You suggest to "Program as much as possible with VB-code". Does that mean that queries and/or macros, unlike VB modules, are loaded into memory regardless of whether they are being used?
 
Back
Top