Access 2007 Error in Loading DLL Revisited
in [General]
|
Prev: Query linked to Excel doesn't work why cant i email things i dont understand
Next: In Windows 7...desktop icon...*My Computer*????
From: Sergio Torres on 21 Mar 2010 22:39 I have MS Office Enterprise 2007 (12.0.6514.5000) SP2 MSO (12.0.6251.5000) on a Windows 7 Ultimate 64 bits. When I open the linked table manager in MS Access and try to check any table I get an error message saying "The expression FldListCheckItem you entered as the event property setting produced the following error: error in loading dll." There is no way for the OK button the get enabled, so I cannot use the linked table manager. If I try to use the Report or Query Wizards I get, twice, a msgbox saying "Error in loading DLL" before the wizards opens. I haven't tried the wizards after the messages. I tried registering dao360.dll and msado15.dll with regsrv.exe... I received a message saying they were registered, but the problem persists. I ran the MS Office Diagnostincs and it found no problem. I uninstalled office and installed it again. The problem is still there. I checked and there are no pending updates. Any ideas? -- Sergio Torres C. (505) 897 2041 ___________________ http://www.stcsys.com ___________________
From: Sergio Torres on 21 Mar 2010 22:49 One more fact. I developed an Access 2000 application that has been running ever since 2000. The owner asked me to upgrade it to MS Access 2007. There were DAO problems and some minor stuff with editing and adding records, But now it seems to be working ok in the owner's PC. Nevertheless, in my PC, I just can't seem to do anything with it (using the 2000 or 2007 formats). I had to go to the owner's PC and do all the work there (running MS Office Pro 2007 on Windows 7 Pro 64 bits.). In my PC, if I try to edit a piece of code in VBA editor window and write, let's say, "Dim db as ". As soon as I press the space bar after the "as" keyword, MS Access crashes and I get a msgbox saying: "Microsoft Office Access has stopped working". The references in the VBA editor window are: Visual Basic For Applications Microsoft Access 12.0 Object Library OLE Automation Microsoft Access 12.0 Access database engine Object Library Microsoft Windows Common Controls 6.0 (SP6) Microsoft ActiveX Data Objects 2.7 Library. I ran the MS Office Diagnostincs and it found no problem. I uninstalled office and installed it again. I checked and there are no pending updates. I checked the event viewer and there appears an error report in the Application log saying: Faulting application name: MSACCESS.EXE, version: 12.0.6423.1000, time stamp: 0x49b08a47 Faulting module name: VBE6.DLL, version: 6.5.10.40, time stamp: 0x48a4b5d6 Exception code: 0xc0000005 Fault offset: 0x001f2bb5 Faulting process id: 0x1110 Faulting application start time: 0x01cac71de6369981 Faulting application path: C:\Program Files (x86)\Microsoft Office\Office12\MSACCESS.EXE Faulting module path: C:\PROGRA~2\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL Report Id: 0bf50e89-3313-11df-bea5-0021705e622f Any ideas? It's getting anoying!!!! -- Sergio Torres C. (505) 897 2041 ___________________ http://www.stcsys.com ___________________ "Sergio Torres" wrote: > I have MS Office Enterprise 2007 (12.0.6514.5000) SP2 MSO (12.0.6251.5000) on > a Windows 7 Ultimate 64 bits. > > When I open the linked table manager in MS Access and try to check any > table I get an error message saying "The expression FldListCheckItem you > entered as the event property setting produced the following error: error in > loading dll." > > There is no way for the OK button the get enabled, so I cannot use the > linked table manager. > > If I try to use the Report or Query Wizards I get, twice, a msgbox saying > "Error in loading DLL" before the wizards opens. I haven't tried the wizards > after the messages. > > I tried registering dao360.dll and msado15.dll with regsrv.exe... I received > a message saying they were registered, but the problem persists. > > I ran the MS Office Diagnostincs and it found no problem. > > I uninstalled office and installed it again. The problem is still there. > > I checked and there are no pending updates. > > Any ideas? > > -- > Sergio Torres C. > (505) 897 2041 > ___________________ > http://www.stcsys.com > ___________________ >
From: John W. Vinson on 21 Mar 2010 23:31 On Sun, 21 Mar 2010 19:49:01 -0700, Sergio Torres <SergioTorres(a)discussions.microsoft.com> wrote: >In my PC, if I try to edit a piece of code in VBA editor window and write, >let's say, "Dim db as ". As soon as I press the space bar after the "as" >keyword, MS Access crashes and I get a msgbox saying: "Microsoft Office >Access has stopped working". > >The references in the VBA editor window are: >Visual Basic For Applications >Microsoft Access 12.0 Object Library >OLE Automation >Microsoft Access 12.0 Access database engine Object Library >Microsoft Windows Common Controls 6.0 (SP6) >Microsoft ActiveX Data Objects 2.7 Library. Try removing the last two. Do you still crash on open? If not, can you compile? Are you in fact *using* ADO or any Common Controls, and if so can you find an alternative? -- John W. Vinson [MVP]
From: Sergio Torres on 22 Mar 2010 12:05 Thank you for your answer. If you don't mind I rather stick to the Linked Table Manager and Report and Query Wizards problem. One way or another I managed to put to work the upgraded Access 2000 application (using its owner PC). I created a new MS Access 2007 database. I added a table to it and linked some tables from "Charitable contributions.accdb" (a database created from a MS Access Template). The report and query wizards behavior is the same, they produce the "error in loading DLL" every time I select an option inside the wizards. In the end reports and queries seems to be created. The Linked Table Manager does not work at all. a) If I click the "Select All" button, the Ok. stays disabled (even if I check the "Always prompt for new location" option). b) If I check any of the existing linked tables, I get the error message "The expression FldListCheckItem you entered as the event property setting produced the following error:Error in loading DLL". As I said before, I registered dao360.dll and msado15.dll and the problem persists. I would really appreciate any help here. Sergio -- Sergio Torres C. (505) 897 2041 ___________________ http://www.stcsys.com ___________________ "John W. Vinson" wrote: > On Sun, 21 Mar 2010 19:49:01 -0700, Sergio Torres > <SergioTorres(a)discussions.microsoft.com> wrote: > > >In my PC, if I try to edit a piece of code in VBA editor window and write, > >let's say, "Dim db as ". As soon as I press the space bar after the "as" > >keyword, MS Access crashes and I get a msgbox saying: "Microsoft Office > >Access has stopped working". > > > >The references in the VBA editor window are: > >Visual Basic For Applications > >Microsoft Access 12.0 Object Library > >OLE Automation > >Microsoft Access 12.0 Access database engine Object Library > >Microsoft Windows Common Controls 6.0 (SP6) > >Microsoft ActiveX Data Objects 2.7 Library. > > Try removing the last two. Do you still crash on open? If not, can you > compile? Are you in fact *using* ADO or any Common Controls, and if so can you > find an alternative? > -- > > John W. Vinson [MVP] > . >
From: Sergio Torres on 22 Mar 2010 12:18
-- Sergio Torres C. (505) 897 2041 ___________________ http://www.stcsys.com ___________________ "John W. Vinson" wrote: > On Sun, 21 Mar 2010 19:49:01 -0700, Sergio Torres > <SergioTorres(a)discussions.microsoft.com> wrote: > > >In my PC, if I try to edit a piece of code in VBA editor window and write, > >let's say, "Dim db as ". As soon as I press the space bar after the "as" > >keyword, MS Access crashes and I get a msgbox saying: "Microsoft Office > >Access has stopped working". > > > >The references in the VBA editor window are: > >Visual Basic For Applications > >Microsoft Access 12.0 Object Library > >OLE Automation > >Microsoft Access 12.0 Access database engine Object Library > >Microsoft Windows Common Controls 6.0 (SP6) > >Microsoft ActiveX Data Objects 2.7 Library. > > Try removing the last two. Do you still crash on open? If not, can you > compile? Are you in fact *using* ADO or any Common Controls, and if so can you > find an alternative? > -- > > John W. Vinson [MVP] > . > |