Access becoming unstable

[Guest]

Hello,

I'm designing a form with a tabbed control, 6 tabs, and a number of subforms
and text controls spread out over those tabs, and I've started to see
messages about a lack of resources and memory, and an inability to undo
things, and even had a few freeze-ups and crashes while switching back and
forth between design view and form view. And I'm only about 2/3 done.
Is this normal? Anything I can do about it? Is the computer memory the
problem?
I already compacted the db from 10 MB to 1 MB, but that didn't improve
things.

 

[Bill Mosca, MS Access MVP]

If you have done a lot of designing, deleting and redesigning, it would
probabaly help if you imported everything into a new blank database. That
should clean up all the fragmented code.

 

[Guest]

Ok, I'll try that. Thank you.

If you have done a lot of designing, deleting and redesigning, it would
probabaly help if you imported everything into a new blank database. That
should clean up all the fragmented code.

 

[Guest]

Didn't help though.

Ok, I'll try that. Thank you.

 

[Bill Mosca, MS Access MVP]

Niniel

Make sure your Name AutoCorrect tracking is off. Tools>Options>General tab.
This "feature" can add a lot of overhead. Also set all the tables'
Subdatasheet property to [none].

The above might not help at all, but they are known for slowing things up.

But when it comes right down to it, 6 tab controls on one form is a lot. You
might want to break it up into a few separate forms.

 

[Guest]

Thank you, Bill.

I was afraid I might have too many tabs and controls. But I'll try your
other ideas first, maybe that'll improve things.

 

[Guest]

Bill,

I switched off Name Auto Correcting, and things are noticeably faster. Not
much more stable, but the speed increase alone is quite nice.

Thanks again.

Niniel

Make sure your Name AutoCorrect tracking is off. Tools>Options>General tab.
This "feature" can add a lot of overhead. Also set all the tables'
Subdatasheet property to [none].

The above might not help at all, but they are known for slowing things up.

But when it comes right down to it, 6 tab controls on one form is a lot. You
might want to break it up into a few separate forms.

--
Bill Mosca, MS Access MVP

Didn't help though.

 

[Bill Mosca, MS Access MVP]

Niniel

The Name AutoCorrect is one of those things most Access developers turn off
before even starting to design a database. It's buggy and does not do a
thorough job.

--
Bill Mosca, MS Access MVP

Bill,

I switched off Name Auto Correcting, and things are noticeably faster. Not
much more stable, but the speed increase alone is quite nice.

Thanks again.

Niniel

Make sure your Name AutoCorrect tracking is off. Tools>Options>General
tab.
This "feature" can add a lot of overhead. Also set all the tables'
Subdatasheet property to [none].

The above might not help at all, but they are known for slowing things
up.

But when it comes right down to it, 6 tab controls on one form is a lot.
You
might want to break it up into a few separate forms.

--
Bill Mosca, MS Access MVP

Didn't help though.

:

Ok, I'll try that. Thank you.

:

If you have done a lot of designing, deleting and redesigning, it
would
probabaly help if you imported everything into a new blank database.
That
should clean up all the fragmented code.

--
Bill Mosca, MS Access MVP


Hello,

I'm designing a form with a tabbed control, 6 tabs, and a number
of
subforms
and text controls spread out over those tabs, and I've started to
see
messages about a lack of resources and memory, and an inability to
undo
things, and even had a few freeze-ups and crashes while switching
back and
forth between design view and form view. And I'm only about 2/3
done.
Is this normal? Anything I can do about it? Is the computer memory
the
problem?
I already compacted the db from 10 MB to 1 MB, but that didn't
improve
things.

 

[Guest]

I surely will do so in the future as well!

Incidentally, your suggestion did solve my crashing problem. I said earlier
that it hadn't because I had a crash shortly after I switched off the
feature, but I haven't had any problems since.
What a relief!

Thanks once more.

 

[Bill Mosca, MS Access MVP]

My pleasure, Niniel.