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: David W. Fenton on 22 Mar 2010 15:12 =?Utf-8?B?U2VyZ2lvIFRvcnJlcw==?= <SergioTorres(a)discussions.microsoft.com> wrote in news:B98B5F5A-9ED3-4A19-A27C-C2F4465FBABA(a)microsoft.com: > As I said before, I registered dao360.dll and msado15.dll and the > problem persists. DAO 3.6 has nothing to do with A2007, nor does ADO 1.5. In general, creating a reference to a library in Access will register it if it's not already registered, but if you aren't using the reference, then Access doesn't need the library to be registered. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/
From: David W. Fenton on 22 Mar 2010 15:13 John W. Vinson <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in news:d0pdq5pbs1sljsa5oi46l33srskg988s61(a)4ax.com: > On Sun, 21 Mar 2010 19:49:01 -0700, Sergio Torres ><SergioTorres(a)discussions.microsoft.com> wrote: > >>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. I would remove the OLE Automation reference, too. If you look at it in the object browser, there's hardly anything of use in it, and I don't understand at all why it is a default reference. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/
From: Maurice on 22 Mar 2010 17:35 It looks like the dll is damaged. Try running the repair option from the about menu (menuoption - about - repair) Backup db just to be sure! -- Maurice Ausum "Sergio Torres" wrote: > 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 23 Mar 2010 23:41 David, Thank you for taking the time to comment on my problem. I mentioned registering dao360.dll and msado15.dll because there are several articles stating that doing so solved the problem with the report and query wizards, as well as with the linked table manager. In my case, it did not help. I am still experiencing the anoying "error in loading DLL" message and my linked tables manager dos not work. -- Sergio Torres C. (505) 897 2041 ___________________ http://www.stcsys.com ___________________ "David W. Fenton" wrote: > =?Utf-8?B?U2VyZ2lvIFRvcnJlcw==?= > <SergioTorres(a)discussions.microsoft.com> wrote in > news:B98B5F5A-9ED3-4A19-A27C-C2F4465FBABA(a)microsoft.com: > > > As I said before, I registered dao360.dll and msado15.dll and the > > problem persists. > > DAO 3.6 has nothing to do with A2007, nor does ADO 1.5. In general, > creating a reference to a library in Access will register it if it's > not already registered, but if you aren't using the reference, then > Access doesn't need the library to be registered. > > -- > David W. Fenton http://www.dfenton.com/ > usenet at dfenton dot com http://www.dfenton.com/DFA/ > . >
From: Sergio Torres on 23 Mar 2010 23:44
Maurice, Thank you for your answer. I am not sure I understand your suggestion. Are you talking about the "Compact and Repair Database" option? Although the database I am working with is brand new I tried that and the problem persists. Sergio -- Sergio Torres C. (505) 897 2041 ___________________ http://www.stcsys.com ___________________ "Maurice" wrote: > It looks like the dll is damaged. Try running the repair option from the > about menu (menuoption - about - repair) > > Backup db just to be sure! > -- > Maurice Ausum > > > "Sergio Torres" wrote: > > > 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] > > > . > > > |