MS Access 2007 ends unexpectetly - Calls VB6 DLL

  • Thread starter Thread starter chris
  • Start date Start date
C

chris

Dear all,

I developed a program in MsAccess 2003/2007 (SP2). It calls a VB6 DLL. Both
office versions call the DLL, Office 2003 does not have any problem. Same DLL
is called in Excel macros (add-in) and works ok, so there seems to be no
problem with VB6 DLL.

On some computers with MS Access 2007, program runs ok.

On some others, when program in MSAccess 2007 opens, first MSAccess form
calls a form from VB6 DLL. The VB form opens for checkings and calls a second
VB form if checks were ok. When second VB form opens, it seems FORM_LOAD
event is executed, I can see the form but then MSAccess closes unexpectetly.
No error, nothing.

Since no error appears, it's not easy to proceed. Can you please help me ?
 
Hi Alex,
I was thinking about this also. I created DLL again. But DLL works ok on few
machines with Office 2007 SP2 and on some not.

On the same machine that DLL does not work in MSAccess 2007, it works ok
when used by Excel VBA (add-in) and forms work without any problem. If they
were not working in Excel also, I would blame the DLL.

Same DLL is used in MSAccess 2003, Excel & Power point 2003 add-ins, without
any problem on all machines that was installed.

That's why I am confused :-(
 
Hi Alex,

in VB6 I create forms that are common to both programs that run in MS Access
& Excel. All of forms receive variables like database object which was opened
from MS Access application.

I noticed that my ABOUT in MS Access says "Access 2007 (12.0.6423.1000) SP 2
MSO (12.0.6425.1000)". If I remember well when I connected remotely to client
machine, they had "Access 2007 (12.0.6425.1000) SP 2 MSO (12.0.6425.1000)". I
asked client to send me print screen for confirming. I do not know whether
this makes a difference, but I will try to create MDE on a machine without
SP2 and see..

Regards,
Chris
 
Hi Alex,

I close all objects I open. MS Access was remaining open and not able to
close in case I was not doing this.

I found out that when machines have Office 2007 service pack 2 and Windows
XP, problem appeared when Windows XP service pack 3 was not installed on
machine. After installing Windows XP, SP3 it works without any problem..
Program installed on other Windows version with Office 2007 works ok.

Thanks a lot for your help.
 
Back
Top