A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

crash on form with two subforms



 
 
Thread Tools Display Modes
  #1  
Old May 20th, 2010, 07:04 PM posted to microsoft.public.access.forms
Trillium97
external usenet poster
 
Posts: 5
Default crash on form with two subforms

Access 2003
I have a form for the user to select a client and then see two subforms:
one with the client's appointments, and another subform with the cats that
the client owns. Both subforms are linked to the select client field on the
main form. We have three users. Back end is SQL. Randomly this form causes
the database to crash with no explanation other than the "sorry there's been
a problem". Usually it's when the user clicks the Close button. This button
does docmd.close and that's all. But yesterday it failed when she had
clicked a different button on the form. It only happens with one user, and
she tends to open and close this particular form often. Could it be the
multiple opening and closing of the form? I have tried many times and I
can't get it to fail. It's happened about once a week for the last three
weeks, but not nearly as routine as that statement makes it sound.

Any ideas are welcome.

I saw the suggestion for Office SP3 and a hotfix, but we can't apply SP3
because it causes another failure with our enterprise messaging client. And
it hasn't failed for me or the other user, and we also don't have SP3.

thanks again.
  #2  
Old May 20th, 2010, 08:19 PM posted to microsoft.public.access.forms
Linq Adams via AccessMonster.com
external usenet poster
 
Posts: 1,474
Default crash on form with two subforms

You say that the back end is SQL (although you don't say SQL what) so I
assume that the database is split.

Does each user have a copy of the front end on their individual hard drive?
Multiple users sharing a single copy of a front end can cause all kinds of
problems, including the one you're encountering.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201005/1

  #3  
Old May 21st, 2010, 04:38 AM posted to microsoft.public.access.forms
Trillium97
external usenet poster
 
Posts: 5
Default crash on form with two subforms

Back end is SQL 2005. Yes the database is split.

All are sharing the front end on the network drive, however generally only
one is in at at time just because of the way we're working with it. I have a
number of small databases at this client and this is the only one with the
problem. In all cases, the front end is on a network share and everyone
opens the same file.

I will try putting the front end on the user PCs but the IT manager doesn't
like that concept. As a test, it will be OK.

Thanks for your thoughts.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:59 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.