Access 2007 Error in Loading DLL

[HHH]

Hi,

When I try to use either the query or report wizard, I get the error message
"Error in Loading DLL." The message comes up twice and then then wizard
window opens. This happens with new or existing databases. I read in an
earlier message to run - regsvr32.exe "c:\program files\Microsoft
office\office11\ACCWIZ.DLL", which I did and it was ok.
Win XP Pro
Thanks,
--
HHH

[Tom Wickerath]

In earlier versions of Access, this error can also indicate an improperly
registered DAO file. I'm honestly not sure about Access 2007, since it can
use two flavors of the JET database engine: regular .mdb and the new
privatized version found in .accdb.

Anyways, you might try reregistering your DAO library:

http://support.microsoft.com/?id=833220

Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

[Tom Wickerath]

In earlier versions of Access, this error can be generated by an improperly
registered DAO library (and apparently by missing, corrupted or outdated MDAC
files as well):

http://support.microsoft.com/?id=833220

I honestly do not know if this applies to Access 2007.

Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

[HHH]

Tom,

I registered both the Dao360.dll and the Msado15.dll files and the wizard
seems to be working. Thanks for your help.
--
HHH

[Tom Wickerath]

Glad to hear that it worked out for you!

Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

[vandana]

Tom,

I am trying to import excel data in access 2007 and in importing spreadsheet
wizard I am getting same error - "error in loading dll". I tried to register
both file on http://support.microsoft.com/?id=833220. but it says "This
article applies only to a Microsoft Access database (.mdb). " while my
database is .accdb and also there is no dll file installed on my computer.
what should I do? please help.

[Jeff Conrad [MSFT]]

Do you have (or did in the past) multiple versions of Access installed on
this PC?

If so which versions and where are they installed - file paths?

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

"vandana" wrote in message:
news:7449F183-0D06-46F4...@microsoft.com...

[vandana]

Jeff,
I do not have any other version of Access installed on my PC. I only have
access 2007 installed right now.

[Sergio Torres]

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.

When working with a MS Access 2003 database (or a copy of it in MS Access
2007 format) 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.

This same MS Access 2003 database (or its 2007 version) work just fine (and
its code can be edited without Access crashing) in another PC running MS
Office Pro 2007 on Windows Home Premium 64 bits.

I tried registering dao360.dll and msado15.dll with regsrv.exe...

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
___________________