"Microsoft Access has stopped working"

[PW]

Hi,

Win7 64-bit, Access 2010 32-bit.

A client reported this last week and the good thing (I suppose) is
that I can duplicate the error on my PC (usually).

I have a form with a third-party ActiveX calendar on it. Here is how
I can usually make Access crash to the desktop with the message in the
subject line (then Access restarts prompting me for a backup
location).

I open up the room calendar and leave it open. I can click on it,
scroll, rebuild it, whatever. I then open up a particular form (it
seems to be the only one that is causing the crash). I save a record,
close the form. Then when I click back on the calendar form, it
usually crashes Access.

I have tried to go into debug mode for both forms but nothing. I
don't even get the chance to step through anything.

I feel helpless to fix this! There doesn't seem to be anything I can
do to try and solve the problem. I contacted the vendor of the
calendar control and they have no idea what the problem is. No
reports of this happening to any of their clients.

I looked at the Windows event log and it lists this error: Faulting
application name: MSACCESS.EXE, version: 14.0.6024.1000, time stamp:
0x4d83e4fc Faulting module name: ntdll.dll, version: 6.1.7601.17725,
time stamp: 0x4ec49b8f Exception code: 0xc0000005

I can't find anything on the web about that error message that seems
appropriate (or really anything at all).

This is happening on my PC, 3 of a clients PC, and other client
versions with the calendar control.

I will take any suggestions! :-)

Thanks,

-paulw

[PW]

Update - I don't even have to click on the calendar form. Sometimes
if I close the other form, Access Crashes.

And a compact and repair did not help.

*-----

[Aikistan]

On Monday, February 4, 2013 7:11:56 PM UTC-5, PW wrote:
> Hi, Win7 64-bit, Access 2010 32-bit. A client reported this last week and the good thing (I suppose) is that I can duplicate the error on my PC (usually). I have a form with a third-party ActiveX calendar on it. Here is how I can usually make Access crash to the desktop with the message in the subject line (then Access restarts prompting me for a backup location). I open up the room calendar and leave it open. I can click on it, scroll, rebuild it, whatever. I then open up a particular form (it seems to be the only one that is causing the crash). I save a record, close the form. Then when I click back on the calendar form, it usually crashes Access. I have tried to go into debug mode for both forms but nothing. I don't even get the chance to step through anything. I feel helpless to fix this! There doesn't seem to be anything I can do to try and solve the problem. I contacted the vendor of the calendar control and they have no idea what the problem is. No reports of this happening to any of their clients. I looked at the Windows event log and it lists this error: Faulting application name: MSACCESS.EXE, version: 14.0.6024.1000, time stamp: 0x4d83e4fc Faulting module name: ntdll.dll, version: 6.1.7601.17725, time stamp: 0x4ec49b8f Exception code: 0xc0000005 I can't find anything on the web about that error message that seems appropriate (or really anything at all). This is happening on my PC, 3 of a clients PC, and other client versions with the calendar control. I will take any suggestions! :-) Thanks, -paulw

Paul,

This seems like a very strange solution but it may be worth a try:

http://social.msdn.microsoft.com/Forums/en/isvvba/thread/99a68e98-d9b7-448f-bc94-d06e994e9ec3

The above link says to turn off "Send to Bluetooth" but further down in the thread the OP suggests that opening and closing the .COM addin window was sufficient to fix it.

Stan

[PW]

I saw that post. But I do not have a "Send to Bluetooth" entry. Only
#401 which is used for Pocket Access, Access 9, SQL Server 7. But
it's not checked any way.

Thanks.

-paul

[PW]

On Tue, 5 Feb 2013 07:59:54 -0800 (PST), Aikistan
<stan.mi...@gmail.com> wrote:

Access is still crashing after opening and closing the .COMM addin
window.

The problem with these "solutions" is that I am not having any problem
opening up the VBA editor. No problem with corruption of my code,
etc....

It is something else.

Thanks,

-paulw

[PW]

This morning Access stopped working with this error in the event log.
I can find nothing relevent by Googling:

Faulting application name: MSACCESS.EXE, version: 14.0.6024.1000, time
stamp: 0x4d83e4fc

Faulting module name: kernel32.dll, version: 6.1.7601.18015, time
stamp: 0x50b83c89
Exception code: 0xc00000fd

[Aikistan]

On Wednesday, February 6, 2013 2:37:53 PM UTC-5, PW wrote:
> Not sure if this is relevant or if you've already seen it but I found the below after searching for just the 0x4d83e4fc (the common item in your two errors).

http://social.msdn.microsoft.com/Forums/en-AU/accessdev/thread/cf61e996-94ea-4efc-bfe1-a8ccf3bf2048

[Aikistan]

On Wednesday, February 6, 2013 4:45:16 PM UTC-5, Aikistan wrote:
> On Wednesday, February 6, 2013 2:37:53 PM UTC-5, PW wrote: > Not sure if this is relevant or if you've already seen it but I found the below after searching for just the 0x4d83e4fc (the common item in your two errors). http://social.msdn.microsoft.com/Forums/en-AU/accessdev/thread/cf61e996-94ea-4efc-bfe1-a8ccf3bf2048

If not, see if you can find common factors between your errors and the client's. That may shed some light. The fact that these are happening all within the same week on different PCs is another clue...but I don't know what it means. Was there a Windows update recently that could have affected all the PCs, anyone?

[Phil]

On 06/02/2013 21:48:31, Aikistan wrote:
> On Wednesday, February 6, 2013 4:45:16 PM UTC-5, Aikistan wrote:
>> On Wednesday, February 6, 2013 2:37:53 PM UTC-5, PW wrote: > Not sure if
> this is relevant or if you've already seen it but I found the below after

> s earching for just the 0x4d83e4fc (the common item in your two errors).
> > http
>://social.msdn.microsoft.com/Forums/en-AU/accessdev/thread/cf61e996-94ea-4e
> http fc-bfe1-a8ccf3bf2048

>
> If not, see if you can find common factors between your errors and the

> clie nt's. That may shed some light. The fact that these are happening all
> wit hin the same week on different PCs is another clue...but I don't know

> what it means. Was there a Windows update recently that could have
> affected all the PCs, anyone?
>

I have been having troube over the last week. Tried opening one db and it
increased in size from about 35Mb to 900,000Mb before system recorces wer
exceeded.

Decompile seems to work (I use a batch file)

Phil

[PW]

It's been happening since Access 2003 I think (but also now with
2010). It is just that one client has started to do things differently
than others, or us.

But now, sometimes if I just click on the form with the ActiveX/COM
calendar on it, it will crash Access. No other forms need to be open.
And it happens for all forms with the control on it. But sometimes I
need to have another form open also along with a calendar form to make
Access Crash. Sometimes it doesn't with the exact same conditions.
Very frustrating!

I changed my UAC setting to normal from the next notch down so now the
event viewer is logging a different error.

The vendor for the control has no idea what the solution could be.

Thanks!

-paulw

[PW]

On Wed, 6 Feb 2013 22:19:55 GMT, "Phil" <ph...@stantonfamily.co.uk>
wrote:

Holy Cow!

I saw suggestions on doing a decompile but I have no problem getting
into VBA or design mode. That is what they all seemed to be about.

[PW]

But I am not getting an error with VBE7.dll and surely Windows Update
must have downloaded the fix since 2011.

Faulting application name: MSACCESS.EXE, version: 14.0.6024.1000, time
stamp: 0x4d83e4fc
Faulting module name: kernel32.dll, version: 6.1.7601.18015, time
stamp: 0x50b83c89
Exception code: 0xc00000fd

Is my current problem.

Thanks.

-paulw

[The Frog]

Well, in my experience errors of this type come from either rubbish
memory management or incorrect API implementation. I am guessing the
control was probably written in C of some flavour.

The error code 0xC00000FD means STATUS_STACK_OVERFLOW (defined in
ntstatus.h). There are many reasons for the exception. Basically it
is due to the damaged state of the stack of the thread.

This is either in my opinion an API your app is calling incorrectly,
or more likely the control is mucking up. The only way to really get
to the bottom of it is to do a system stack / trace dump and analyse
it. This is a hell of a lot of work.

Simpler I think to replace the control with another and if pain
persists take a dump. :-) This is probably not worth getting to the
bottom of.

--
Cheers

The Frog

[PW]

On Thu, 07 Feb 2013 22:50:44 +1100, The Frog
<Mr.frog...@googlemail.com> wrote:

>Well, in my experience errors of this type come from either rubbish
>memory management or incorrect API implementation. I am guessing the
>control was probably written in C of some flavour.
>

I bet you are right.

>The error code 0xC00000FD means STATUS_STACK_OVERFLOW (defined in
>ntstatus.h). There are many reasons for the exception. Basically it
>is due to the damaged state of the stack of the thread.
>

I saw that when googling last night.

>This is either in my opinion an API your app is calling incorrectly,
>or more likely the control is mucking up.

I just place the control on a form and write code to fill the
calendar. I think the problem is on their end (dbi-tech) and they
don't have any Access people working for them so I don't see how they
can or will resolve this.

> The only way to really get
>to the bottom of it is to do a system stack / trace dump and analyse
>it. This is a hell of a lot of work.
>

That is what I read.

>Simpler I think to replace the control with another and if pain
>persists take a dump. :-) This is probably not worth getting to the
>bottom of.

Well, it took months for me to figure out how to program the control
and come up with our calendars. We need a special format to them. I
found a couple other calendars but they are like the Outlook calendar
(squares) and that will not work.

I do need to get this resolved. Our clients depend on our calendars.

Thanks!

-paulw

[Phil]

Don't know what you're after, but there's an example of a celendar at
http://www.flickr.com/photos/philofwaltonspics/

either enter information directly or extract it from Google calendar

Phil

[The Frog]

Phil that is a great calendar. Brilliant in fact. Did you craft this?
That is absolutely top notch.

--
Cheers

The Frog

[PW]

>Don't know what you're after, but there's an example of a celendar at
>http://www.flickr.com/photos/philofwaltonspics/
>
>either enter information directly or extract it from Google calendar
>
>Phil

Great looking calendar, but it is still traditional "squares". The
client would not be able to see everything going on for the day at
once (unless there were scroll bars for each day but that would be a
pain).

Oh, I do see each day has a record selector.

Like this: http://www.williamsonenterprises.com/lgalleryforms.htm

Second thumbnail page, third one (6th picture total) which is a
simplified version of what the room calendar looks like now (I need to
update that image!) but not with alot of data in it. Basic premise
though. Rooms, resources, employees, etc.... on the left with related
timebars to their right for either dates or time.

Thanks Phil!

Did you do that calendar in Access?

-paul

[The Frog]

Looks a lot like a Gannt chart, often used in project management. Is
the calendar you use 'live' or just a static display of already
entered data. Can users edit data directly in the calendar?

--
Cheers

The Frog

[PW]

On Fri, 08 Feb 2013 10:55:04 +1100, The Frog
<Mr.frog...@googlemail.com> wrote:

>Looks a lot like a Gannt chart, often used in project management.

Yep! I can even have lines drawn between timebars but I don't
understand why. Over my head.
http://www.dbi-tech.com/ProductPage_SolutionsSchedule.aspx

>Is
>the calendar you use 'live' or just a static display of already
>entered data. Can users edit data directly in the calendar?

Static data. Well, other users could be entering in related data but
the calendar would have to be refreshed to reflect the changes.

But that is not what is happening on my PC. Just me testing the
calendars.

I can have a calendar open with another form that doesn't use any of
the tables that the calendar uses (employee calendar+ dog entry form)
and if I press the save button on the non-calendar form, then click
the calendar it will crash Access.

It doesn't matter if I open up the code ACCDB with the shift key, run
the ACCDB, or ACCDR.

Back to the ntdll.dll error from the kernal error now!

Faulting application name: MSACCESS.EXE, version: 14.0.6024.1000, time
stamp: 0x4d83e4fc

Faulting module name: ntdll.dll, version: 6.1.7601.17725, time stamp:
0x4ec49b8f

Exception code: 0xc00000fd
Fault offset: 0x000221ef
Faulting process id: 0x103c
Faulting application start time: 0x01ce058f0bf1fbdc
Faulting application path: C:\Program Files (x86)\Microsoft
Office\Office14\MSACCESS.EXE
Faulting module path: C:\Windows\SysWOW64\ntdll.dll
Report Id: 02b1ad1d-7184-11e2-8ca3-00252242c92e


DBI has been great with their support. Working their butts off but
they can't recreate the crashing! I am going to send them a ACCDB
(data and code) with a calendar and a form and see if it crashes
there.

But Access crashes on my PC, my wife's, four PCs at a client site, and
with other versions.

Aaaaargh!

Thanks,

-paulw

[The Frog]

I'm guessing now that the tools / controls GDI calls are up the
pooper and thats not something you can fix.

My suggestion is to swap it with a Gannt chart as a report. If you're
not using it to enter data then dump the control and use a report you
can contain completely in Access. I imagine some of our long term
gurus have a way of achieving that. If not we could pull some
techniques from Excel and VBA and bend them to the task at hand.

--
Cheers

The Frog

[PW]

On Fri, 08 Feb 2013 10:55:04 +1100, The Frog
<Mr.frog...@googlemail.com> wrote:

> Can users edit data directly in the calendar?

Oops. Yes, if I could figure it out (I have not taken the time yet).
They would have to draw a timebar and I would have to make that work.
However, drag and drop is not available in the Access GUI (not
possible to take a timebar and move it to another slot). I guess I
could make it so after the user creates a timebar for a room
assignment for a particular date range, I could bring up the client
form if the client doesn't exist or reservation form if the client
does exist - so they could enter data there. And then refresh the
calendar.

I made it so when the user clicks on a time bar, the room and
reservation information appear up top (I could not get the tooltip
feature to work - most likely me!). And they can double-click on a
timebar and go to the reservation.

I've done lots of color coding for various things (like payment is
due, deposit received, reservation confirmed, etc....) and also have
used various hash bars to signify other things or events.

And a bunch of other calendars for different things like resources
assigned and available, employee schedules, etc...

-paulw

[Phil]

Actually the calendar consists of 42 subforms (1 for each day) but only the
28, 30 or 31 days show.

Double click on the yellow date to get an hourly calendat up
Double click on the event to get a more detailed event form up. That is where
you add new records. In fact as I mentioned, it is used as a method of
printing formatted reports from Google Calendar. Great fun unscrambling
Google Calendars output file so that I could import it into the database.

Bit more stuff on the http://www.flickr.com/photos/philofwaltonspics/ link

Phil

[PW]

On Mon, 04 Feb 2013 17:11:56 -0700, PW
<emailad...@ifIremember.com> wrote:

I made a sample database with one calendar form and one regular
unrelated form and sent it to DBI (who's ActiveX calendars were
causing Access to crash). They were, thankfully, able to reproduce my
problem. Opening up a calendar form first, then another form then back
to the calendar form would crash Access.

They have no idea what is going on but are guessing that it might have
something to do with the OLEContainer used in Access, and focus. They
are still baffled. And they experienced the same strange behaviours
that I was experiencing (like commenting out the code in the New,
Save, Close, Delete, Print buttons would not crash Access).

They worked their butts off and I will nost likely be renewing my
annual support agreement.

They are still researching what the heck the problem is but they
offered a temporary solution (which is working so far!!!!!):

In the calendar form, toggle the Enabled property of the calendar
control by using the Activate and Deactivate properties). I don't
think I've ever used those before.

YeeHaw!!!

-paulw

[The Frog]

Would you consider your issue with this control handled for now?

--
Cheers

The Frog

[PW]

On Mon, 11 Feb 2013 09:41:13 +1100, The Frog
<Mr.frog...@googlemail.com> wrote:

>Would you consider your issue with this control handled for now?

Yes, until I get client confirmation(s) this week. And I should have
said that the Activate/Deactivate properties are form properties, not
control properties. Never used them before.

I just got all 6 of our fancy calendars working w/o crashing Access. I
cannot believe that other clients are not reporting this problem. I
guess they do things differently (like close all calendars before
opening other forms? Got me!).

DBI is still doing research on WTH is going on since I guess I am the
only one out of hundreds(?) of their clients that reported this. But
their "temporary" resolution seems to be working. In a week or so, I
should know for sure.

Leave it to me! :-)

Thanks for checking in!

-paulw

[Aikistan]

On Sunday, February 10, 2013 11:21:58 PM UTC-5, PW wrote:
> On Mon, 11 Feb 2013 09:41:13 +1100, The Frog
> <Mr.frog. wrote:
>
> >Would you consider your issue with this control handled for now?
>
> Yes, until I get client confirmation(s) this week. And I should have
>

Excellent news! It's great that the vendor is working with you. Sorry my guesses weren't more helpful but I'd discounted the application being to blame, since it had been working fine before. Very strange that it happened suddenly and that they were still able to replicate it.

Stan

[PW]

Finger pointing is what they have done in the past. They must have
some new blood there. But to be honest, they were probably right at
times. It is nice to see that they have someone that knows VBA and
Access now.

I did not expect them to be able to duplicate the issue! So relieved!

I am waiting for the client that reported the problem to tell us that
it is fixed. I cannot wait! It is very weird that other clients have
not reported the same issue, because I can make it happen on their
versions. At least the crashes seem consistant, because that helps
with debuggin <g>.

I learned alot from your "guesses"!

Thanks so much.

-paulw

[Access Developer]

Remember the old story?

Patient: "Doctor, it hurts when I do this."
Doctor: "Don't do that."

There are many non-ActiveX calendar solutions available. One I've used is
by Access MVP Arvin Meyer. I'd guess it is still available somewhere on his
site. There's a list of (mostly MVP or former-MVP) sites at
http://sp.ntpcug.org/accesssig.

Not only do you not run into "mystifying-not-working" messages, but you also
don't have to install Yet Another ActiveX Control. It's all done within
Access itself, using Access objects and VBA. Caveat: if you are doing an
Access Web App, it may or may not work.

--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010

"PW" <emailad...@ifIremember.com> wrote in message
news:db46h8d6mjddu1f0a...@4ax.com...

[Access Developer]

One general comment: not every ActiveX control will work with Access.

Many creators of ActiveX controls have told us, "Of course, it will work."
even though they know nothing about Access and have never tested their
control with Access. Then, when their control doesn't work, they say, "Oh,
that's an Access problem; our control meets all the ActiveX requirements."

--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010

"PW" <emailad...@ifIremember.com> wrote in message

news:40j0h8tc055bjjkdl...@4ax.com...

[PW]

On Sat, 16 Feb 2013 15:17:18 -0600, "Access Developer"
<accd...@gmail.com> wrote:

>One general comment: not every ActiveX control will work with Access.
>
>Many creators of ActiveX controls have told us, "Of course, it will work."
>even though they know nothing about Access and have never tested their
>control with Access. Then, when their control doesn't work, they say, "Oh,
>that's an Access problem; our control meets all the ActiveX requirements."

I have heard that before Larry!