maximum number of controls on a form

  • Thread starter Thread starter Mark Kubicki
  • Start date Start date
M

Mark Kubicki

I know that Access has a maximum number of controls allowed on a form, and
that this limit is OVER THE LIFE OF THE FORM (vs. what is currently on the
form)

I have a form which I know has been reworked MANY times, and I notice that
lately, when I try adding a control often it crashes the form in a way that
makes it unusable (it crashes during the form save)

To recreate this form from scratch would involve a weeks worth time (well,
at least a couple of days..)

Q.
- is there a way to tell what Access thinks is the current count of
controls?
- can the number be reset to what is currently on the form ONLY?
- could there be something else that is causing the crashes (having to
restore back-ups is almost a daily occurrence (now days, I back-up allot
!!!)
 
that "life" is re-set if you open the from in design mode, and do a save-as.

Now, delete the original form, and then simply re-name the one you just
saved.

You should do compact and repair at this point.
Q.
- is there a way to tell what Access thinks is the current count of
controls?
Click to expand...

Yes, the above will do so.
- can the number be reset to what is currently on the form ONLY?
Click to expand...

Yes, just do a save-as as per above.
- could there be something else that is causing the crashes (having to
restore back-ups is almost a daily occurrence (now days, I back-up allot
!!!)
Click to expand...

I find access VERY stable. Two things:

If access does crash, then you REALLY need to do a de-compile on that
application (as it now damaged). Make sure you hold down the shift key when
you do the de-compile to ensure no startup code runs at all. I then suggest
you exit..and again re-enter (again shift key). Now do a compact repair.

So, if access crashes, then your application now going to be un-stable until
you do the above.

Also, if this is multi-user, then split the application, and distribute mde
to EACH desktop. I had customers running applications with my all day long
with about 4-5 users for 9 years straight, and I don't the application has
ever hung up once. Mind you small applications with 50-60 highly related
tables and tiny table sizes of 65,000 records is small, but in this case the
applicaon does have about 160 forms, and I not have one phone call in 9
years that it every hung up.

So, in my experience I find access very stable indeed. If you having
problems of stability, something is wrong here...
 
Thanks for your insight to the stability of Access (I actually, in my naive
exposure) agree, it is.

The crashes that I have are solely related to forms, and always occur during
the save process (either after lengthy editing, or simply after adding a
single control.) Usually access shuts down and asks to back-up and
recover... Sometimes the form is usable when the project reopens, sometimes
it is not. Occasionally, the form takes a long time (several minutes to
save, often it saves in a matter of seconds; usually, the two scenarios
happen in cycles: it continually takes a long time, then suddenly, it starts
saving quickly, only to revert, after "some" increment, back to lengthy save
times.(this makes me think I do have an "issue".

Of course, I have no idea where to look, and if you have any additional
thoughts on this, they would also be greatly appreciated...

Mark.

----------------------------------------------------------------------------------------------
 
Back
Top