J
Jon Furman
OK I got big troubles on my main development machine, I'm hoping maybe
someone else can add some insight to how to fix my problem. Here's what
happened. I was working with an ADP and started getting "could not load DLL"
errors while writing some VBA code. At first I thought it was my code but
upon rebooting and creating a new empty MDB I discovered it wasn't. Every
time I would write a line of VBA code that used intellisense or referenced
an object property Access would crash with a fault error. For example upon
trying to type the statement Me.Caption ="Help" Access crashes the second I
finished typing 'Me.' . Strangely if I pasted in Me.Caption ="Help" there
are no problems. I did a repair from the installation disk but that didn't
help. Then I reapplied the latest service packs but still no go. I also
noticed that VBA in the other office apps was working fine. I uninstalled
office and reinstalled, still no luck. Then I uninstalled Office and deleted
the directories where it was located and then reinstalled, still didn't
work. Then I ran a Doc Watson on it and extracted this from the log:
State Dump for Thread Id 0xb9c
eax=00000000 ebx=00000000 ecx=001598dc edx=77a3fcc8 esi=089b0180
edi=00000000
eip=650ad365 esp=0012f92c ebp=0012f934 iopl=0 nv up ei pl zr na po
nc
cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000
efl=00000246
function: DllCanUnloadNow
650ad352 6a01 push 0x1
650ad354 ebf8 jmp DllCanUnloadNow+0xcff7 (650b294e)
650ad356 55 push ebp
650ad357 8bec mov ebp,esp
650ad359 8b4508 mov eax,[ebp+0x8]
ss:00c1981a=????????
650ad35c 56 push esi
650ad35d 57 push edi
650ad35e 33ff xor edi,edi
650ad360 833819 cmp dword ptr [eax],0x19
ds:00000000=????????
650ad363 7455 jz DllCanUnloadNow+0xfd63 (650b56ba)
FAULT ->650ad365 833816 cmp dword ptr [eax],0x16
ds:00000000=????????
650ad368 7458 jz DllCanUnloadNow+0x1056b (650b5ec2)
650ad36a 8b08 mov ecx,[eax]
ds:00000000=????????
650ad36c 83f913 cmp ecx,0x13
650ad36f 7c41 jl DllCanUnloadNow+0xfd5b (650b56b2)
650ad371 83f914 cmp ecx,0x14
650ad374 7f51 jg DllCanUnloadNow+0x10570 (650b5ec7)
650ad376 8b7008 mov esi,[eax+0x8]
ds:00ae9ee6=????????
650ad379 8a4608 mov al,[esi+0x8]
ds:0949a066=??
650ad37c 240f and al,0xf
650ad37e 3c05 cmp al,0x5
650ad380 1bc0 sbb eax,eax
*----> Stack Back Trace <----*
FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
0012F934 650AD3E2 089B0160 00000000 00000000 650AC499 Vbe6!DllCanUnloadNow
0012F958 650AC2F3 089A0340 00000000 00000000 650AC499 Vbe6!DllCanUnloadNow
0012F974 65189B2B 089A0390 650AC499 0012F9AC 00000000 Vbe6!DllCanUnloadNow
00000000 00000000 00000000 00000000 00000000 00000000
Vbe6!rtcSetDatabaseLcid
I took that to mean that the error occurred in VBE6.dll, so I replaced that
file with a known good version and manually registered it with regsvr. Still
the same problem persisted. I'm at wits end now and have no idea what to do
past what I've outlined above to try to get Access working again. I have a
lot of stuff installed on this machine and do not want to reinstall the OS
and rebuild as that will set my real work behind by at least several days,
probably an entire week.
I'm using Office XP, but have 2K and 97 installed as well. The same problem
happens in XP and 2K, but 97 is fine. Right now I have wiped XP and 2K from
the system and am trying to resolve the problem with the 2K version. I
figure once I get that working I figure that I can add the XP version
without additional troubles. Here's a little more background, the last thing
I did to the system was to do a repair install on Visual Studio 2002, but
I'm not sure if this is what set off the troubles.
Thanks for reading, hoping that maybe someone else has been through this one
and can help.
Jon
someone else can add some insight to how to fix my problem. Here's what
happened. I was working with an ADP and started getting "could not load DLL"
errors while writing some VBA code. At first I thought it was my code but
upon rebooting and creating a new empty MDB I discovered it wasn't. Every
time I would write a line of VBA code that used intellisense or referenced
an object property Access would crash with a fault error. For example upon
trying to type the statement Me.Caption ="Help" Access crashes the second I
finished typing 'Me.' . Strangely if I pasted in Me.Caption ="Help" there
are no problems. I did a repair from the installation disk but that didn't
help. Then I reapplied the latest service packs but still no go. I also
noticed that VBA in the other office apps was working fine. I uninstalled
office and reinstalled, still no luck. Then I uninstalled Office and deleted
the directories where it was located and then reinstalled, still didn't
work. Then I ran a Doc Watson on it and extracted this from the log:
State Dump for Thread Id 0xb9c
eax=00000000 ebx=00000000 ecx=001598dc edx=77a3fcc8 esi=089b0180
edi=00000000
eip=650ad365 esp=0012f92c ebp=0012f934 iopl=0 nv up ei pl zr na po
nc
cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000
efl=00000246
function: DllCanUnloadNow
650ad352 6a01 push 0x1
650ad354 ebf8 jmp DllCanUnloadNow+0xcff7 (650b294e)
650ad356 55 push ebp
650ad357 8bec mov ebp,esp
650ad359 8b4508 mov eax,[ebp+0x8]
ss:00c1981a=????????
650ad35c 56 push esi
650ad35d 57 push edi
650ad35e 33ff xor edi,edi
650ad360 833819 cmp dword ptr [eax],0x19
ds:00000000=????????
650ad363 7455 jz DllCanUnloadNow+0xfd63 (650b56ba)
FAULT ->650ad365 833816 cmp dword ptr [eax],0x16
ds:00000000=????????
650ad368 7458 jz DllCanUnloadNow+0x1056b (650b5ec2)
650ad36a 8b08 mov ecx,[eax]
ds:00000000=????????
650ad36c 83f913 cmp ecx,0x13
650ad36f 7c41 jl DllCanUnloadNow+0xfd5b (650b56b2)
650ad371 83f914 cmp ecx,0x14
650ad374 7f51 jg DllCanUnloadNow+0x10570 (650b5ec7)
650ad376 8b7008 mov esi,[eax+0x8]
ds:00ae9ee6=????????
650ad379 8a4608 mov al,[esi+0x8]
ds:0949a066=??
650ad37c 240f and al,0xf
650ad37e 3c05 cmp al,0x5
650ad380 1bc0 sbb eax,eax
*----> Stack Back Trace <----*
FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
0012F934 650AD3E2 089B0160 00000000 00000000 650AC499 Vbe6!DllCanUnloadNow
0012F958 650AC2F3 089A0340 00000000 00000000 650AC499 Vbe6!DllCanUnloadNow
0012F974 65189B2B 089A0390 650AC499 0012F9AC 00000000 Vbe6!DllCanUnloadNow
00000000 00000000 00000000 00000000 00000000 00000000
Vbe6!rtcSetDatabaseLcid
I took that to mean that the error occurred in VBE6.dll, so I replaced that
file with a known good version and manually registered it with regsvr. Still
the same problem persisted. I'm at wits end now and have no idea what to do
past what I've outlined above to try to get Access working again. I have a
lot of stuff installed on this machine and do not want to reinstall the OS
and rebuild as that will set my real work behind by at least several days,
probably an entire week.
I'm using Office XP, but have 2K and 97 installed as well. The same problem
happens in XP and 2K, but 97 is fine. Right now I have wiped XP and 2K from
the system and am trying to resolve the problem with the 2K version. I
figure once I get that working I figure that I can add the XP version
without additional troubles. Here's a little more background, the last thing
I did to the system was to do a repair install on Visual Studio 2002, but
I'm not sure if this is what set off the troubles.
Thanks for reading, hoping that maybe someone else has been through this one
and can help.
Jon