Form opening/saving very slowly

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Brian (Brian_at_discussions.microsoft.com)
Date: 01/08/05 

Date: Sat, 8 Jan 2005 09:47:05 -0800

I have a particular form that rather suddenly has become very slow when
saving (over 20 seconds) or when switching from design to form view after a
change has been made. It opens fast enough when no change has been made, but
is slow saving whether anything has changed or not. It is fairly complex (38
bound controls, 24 unbound); however, I am unable to make it any less complex
without significantly complicating the user interface with multiple forms.

I already tried these, to no avail:
  Compact/repair
  Create a completely blank DB, then import all my forms
  Compile VBA

What does Access do when saving the form? Does it validate row sources,
etc.? Are there any options I can set to alleviate this problem?

Relevant Pages

  • RE: Resizing Popup/Modal forms
    ... modal and pop-up values to "yes" and saving that. ... > design view and then changed the border style to Thin; ... > Can somebody help me and tell me how I can resize a popup/modal form to the ...
    (microsoft.public.access.forms)
  • Re: Break into the Form Close event
    ... Edgar Rodriguez ... >Got a form with a database table ... >Got an OK button that checks certain fields before saving the table. ... >Should I design my form better? ...
    (borland.public.delphi.language.objectpascal)
  • Re: textedit...
    ... >There's an option to convert it to pure text BEFORE saving. ... Bad UI design, IMHO. ... plain text with the myriad dialog warnings in Microsoft Office about ... certain file formats not supporting all features. ...
    (comp.sys.mac.advocacy)
  • Changes Not Saved
    ... next day I opened the form and continued to design the form. ... Saving ... JoJo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11307 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • A Problem Using Microsoft Agent in FrontPage 2003
    ... about the ActiveX content whenever saving or switching from CODE to DESIGN ...
    (microsoft.public.frontpage.client)