MS Access 2007 ends unexpectetly - Calls VB6 DLL

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 ?
 
C

chris

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 :-(
 
C

chris

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
 
C

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Option buttons become black - no text shown 9
Problem creating web service wrapper for VB6 COM DLL that calls C++ DLL 1
Access crashes when calling DLL function. 5
Reference a VB 6.0 DLL, causes Access not to be able to close 4
Access 2007 and spreadsheet in a form 1
Using an Access Library in Access 2000 2
Calling Win32 functions from DLL library 8
VBA to VB6 DLL, interface split to support Excel 2000-2003, 2007 5

Top