Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2010
    Posts
    1

    Unanswered: After upgrading to 2007 my Forms are very slow

    Here's the situation. I have split a db into a BE/FE because we have remote users. The database works fine for local users (Each user has his/her own FE) for offsite users (Not more than 30 miles away) the performance is lethargic at best. Not matter the number of users, the speed doesn't change. The db opens and closes fine, generates 30 page reports in 20-30 sec (currently this is acceptable). But I've got two forms that have 2 subforms each. The total records for these forms is <300. The form opens quickly, but paging through the records is painfully slow. One for has a query for it's record source and one a table, both perform the same. This db worked perfectly in Access 2003, two weeks ago we upgraded, so it's been about two weeks of hair pulling with only slightly better results. I've officially ran out of ideas. I've read quite a bit here: Microsoft Access Performance - Forms and actually the persistent connection did help opening / closing / running reports, but nothing has helped the lag of paging through these two forms. Thanks for the help

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    I assume by "off-site users" you're speaking of a WAN. Albert Kallal has a paper on the subject here:

    MS Access on a WAN?

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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