From: Sergio Torres on
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
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
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
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

--
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]
> .
>