Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Mar 2004
    Location
    White Oak, Pennsylvania, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form too complex? (2002 (SP3))

    We're using a form in Access that displays lots on information from various tables about members - it takes a long time to load the form on the networked computers. Here's the time involved:
    Using Windows XP Pro (SP2) and the MS Network
    PCs with 256 MB RAM load in 3 mins. 10 secs.,
    512 MB RAM load in 2 mins.
    1GB RAM load in 1 min. 55 secs.

    My computer - not networked XP home edition (SP2) - 512MB Ram - 5 seconds

    Any way to speed up the load on the Networked computers?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form too complex? (2002 (SP3))

    Anti-virus software can really slow down Access. See if the AV software on your PC is set to scan network drives. If so, try turning this off (the file server should do the scanning, so security should not be compromised).

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form too complex? (2002 (SP3))

    This is a common troubling issue but here are some things I've tried:
    - Try placing the front-end on a local drive and the back-end on the server
    - If you don't need all the data all the time, you could reduce the number of record sources by removing some of the tables and fields on the form, then if someone needs to see a particular piece of information about that member, they could click a button to bring up a sub-form containing the critical piece of information
    - If updating data isn't necessary and real-time isn't important, you could create a table off your original record source (using a make-table query or a delete & append query combo) when the person opens the database, house the data locally then have the form reference the table...it's a little odd but will improve speed (just make sure to set the compact on close to yes and make sure the front-end is on the local hard drive.
    - Set the record source to key off a combo box on the form. Then when they open the form, no records load and it will open more quickly. Then when they select a member from the combo box, the form will update and will reflect the member selected.
    Hope these ideas help.
    Andrew

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Form too complex? (2002 (SP3))

    Have you tried turning AutoCorrect off.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •