Access 2007 Crashing

[Lou O]

I am working on a rather large application using Access 07
The application has been growing a lot lately in terms of objects and
modules.
About a week ago the application began to crash intermittently in
design mode.
The forms that seem to cause the most problems are very largely
populated with controls
Save operations for these forms take several minutes to complete.
During the save the screen sometimes goes completely white. Scary!
I'm wondering if there is a limit to form size or perhaps app size in
Access.
My app is around 13 meg compacted.
Smaller apps around 3 megs have no problems in this regard.
Am I perhaps dealing with a corrupt DB?
Any insight would be appreciated.

[Tony Toews [MVP]]

Lou O <lg********@gmail.comwrote:

>During the save the screen sometimes goes completely white. Scary!

That's not a problem. I get that happening in non Access windows when there is some
kind of wierd background or video refresh and the foreground window is stalled. Such
as a browser opening a complex page or some such. I also get that happening in
Access occasionally as well so its just being non responsive here as well.

You do have a problem though don't get me wrong. <smile>

Are you working with the FE MDB over the network or is it on your local hard drive?
Do you always have a form bound to a table or query against the BE MDB or recordset
open to a table linked to the BE?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Lou O]

On Sep 25, 6:16*pm, "Tony Toews [MVP]" <[e-mail]:

Lou O <[e-mail]:

During the save the screen sometimes goes completely white. Scary!

That's not a problem. *I get that happening in non Access windows when there is some
kind of wierd background or video refresh and the foreground window is stalled. *Such
as a browser opening a complex page or some such. *I also get that happening in
Access occasionally as well so its just being non responsive here as well..

You do have a problem though don't get me wrong. *<smile*

Are you working with the FE MDB over the network or is it on your local hard drive?
Do you always have a form bound to a table or query against the BE MDB orrecordset
open to a table linked to the BE?

Tony
--
Tony Toews, Microsoft Access MVP
* *Please respond only in the newsgroups so that others can
read the entire thread of messages.
* *Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
* *Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

Tony,
My FE is local.
There is usually an open form (switchboard) bound to a table in the
BE.
However the problem form is bound to a temp table in the FE.
Something that I noticed since my last post.
If I use Ctrl + S to save rather than the the menu save button, the
save operation is noticeable faster but only if there are no multiple
objects to save.
Could it have something to do with the save dialogue window?
By the way, I wonder if I can I disable the save dialogue window? I
find it annoying most of the time.
Lou

[Lou O]

On Sep 25, 6:16*pm, "Tony Toews [MVP]" <[e-mail]:

Lou O <[e-mail]:

During the save the screen sometimes goes completely white. Scary!

That's not a problem. *I get that happening in non Access windows when there is some
kind of wierd background or video refresh and the foreground window is stalled. *Such
as a browser opening a complex page or some such. *I also get that happening in
Access occasionally as well so its just being non responsive here as well..

You do have a problem though don't get me wrong. *<smile*

Are you working with the FE MDB over the network or is it on your local hard drive?
Do you always have a form bound to a table or query against the BE MDB orrecordset
open to a table linked to the BE?

Tony
--
Tony Toews, Microsoft Access MVP
* *Please respond only in the newsgroups so that others can
read the entire thread of messages.
* *Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
* *Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

Tony,
My FE is local.
There is usually an open form (switchboard) bound to a table in the
BE.
However the problem form is bound to a temp table in the FE.
Something that I noticed since my last post.
If I use Ctrl + S to save rather than the the menu save button, the
save operation is noticeable faster but only if there are no multiple
objects to save.
Could it have something to do with the save dialogue window?
By the way, I wonder if I can I disable the save dialogue window? I
find it annoying most of the time.
Lou

[Allen Browne]

Yes, Access is likely to make a separate connection for each one. You may be
able to fudge something to fix that, particularly if there are thousands of
records in the lookup tables that feed the combos.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.>

I destroyed the code.
The form still saves slowly so the trouble seems to be in the form
itself.
Can there be corruption in the form or controls?
There's something I just thought of in regard to Tony's earlier post.
There are quite a number of list and combo boxes on the form.
These all have different Rowsource queries bound to tables in the
networked BE database.
Maybe I have too many of these kinds of controls on the form.
And maybe my network can't handle all the requests.
I'll try bringing the BE to the local machine to see if it makes any
difference.