Access XP takes a long time to save changes

  • Thread starter Thread starter JP
  • Start date Start date
J

JP

Hi,

I have a small database, about 60MB, with 15 forms, and
quite a bit of VBA code on each form. I recently added a
tab control to the bottom of each form that has
contributed to the large amount of code.

Now when I make any sort of changes to the form, and save,
it can take 20 minutes to save and close the database or
the form.

I have a decent machine, 2.1Ghz, 512MB RAM, etc. I'm
running Office XP SP2.

Anybody else ever experienced excessive save times with
forms that have large amounts of VBA code?

Thanks,

JP
 
Hi Andy,

I compile the code and compact the DB on a regular basis.
My next step is to run the DB on a barebones machine with
nothing but Windows 2000 and Access XP and we'll see what
happens.

Thanks,

JP
 
Dear JP:

I'm no expert, so take this for what it's worth! <g> However, I recently
dealt with a problem which was somewhat similar to what you describe. Do you
have a Front End/Back End setup? And is there a chance that you might be
working on and saving your forms when someone else is accessing the Back End
MDB? In my case, it was taking several minutes to save changed forms when
there was anyone else accessing the Back End at the same time. If I was the
only user of the Back End, the problem vanished. If this sounds like your
situation, then maybe you are dealing with the LBD Locking issue, as
described by Tony Toews here:
http://www.granite.ab.ca/access/performancefaq.htm .

If this isn't relevant to your situation, sorry!

HTH
Fred Boer
 
JP said:
Hi,

I have a small database, about 60MB, with 15 forms, and
quite a bit of VBA code on each form. I recently added a
tab control to the bottom of each form that has
contributed to the large amount of code.

Now when I make any sort of changes to the form, and save,
it can take 20 minutes to save and close the database or
the form.

I have a decent machine, 2.1Ghz, 512MB RAM, etc. I'm
running Office XP SP2.

Anybody else ever experienced excessive save times with
forms that have large amounts of VBA code?

Thanks,
Click to expand...

In addition to the other suggestions, which are good ones, have a look
at the setting of the Name AutoCorrect option (Tools -> Options... ->
General).

If "Track name AutoCorrect info" is checked, see if unchecking it
improves the situation.
 
Back
Top