Microsoft Access 2007 In Vb6 Runtime

Posted onby

It works fine on all systems from 8.1 and down with either a full version of Access 2007 installed or the Runtime version of Access 2007 installed. It breaks on the Windows 10 system with a full version of Access 2007 installed. The Microsoft Office Access 2007 Runtime enables you to distribute Access 2007 applications to users who do not have the full version of Access 2007 installed on their computers. Connecting VB6 and MS Access 2007. Select Microsoft Office 12 access database engine object library c) Select Microsoft Office 12 object library 4) no special code changes needed when setting db objects I hope these suggestions and the links provided will give you some more insight into the relationship between VB 6 and Access 2007.

Active8 years, 8 months ago

I have programmed an Access Database program using Access 2007. I have a button that points to the event: DoCmd.SendObject acSendReport to have it email a PDF report (acFormatPDF). Everything works fine in the normal Access 2007 program, but when a user opens the program with Access 2007 Runtime, when clicking on this button it goes through the normal steps (notifying Outlook, waiting for Allow/Deny clearance), and then after you click Allow, the program crashes with a Runtime Error.

Does anybody know what is going on here? Is this a normal error with Access Runtime? I have tried other file formats (RTF and XLS) instead of PDF, but it seems to be the SendObject command that is crashing the Runtime Environment?

Clarification: Access Runtime does not output an error code upon this crash. Just a window stating a 'runtime error has occurred'.

Microsoft Access 2007 In Vb6 Runtime

2 Answers

It seems that the runtime license doesn't not cover the PDF converter. However, this article:

purportedly explains how to chain the PDF converter installer with your runtime installer so that it will be part of the runtime installation. Unfortunately, subsequent discussion on that page shows that PDF output didn't actually work with the runtime. The SP2 for the runtine purportedly also fixes the problem:

but some commenters there report nonspecific PDF issues. So you might want to check if you've got SP2 of the runtime and see if you can then use the PDF converter.

Sorry not to be of more help here, but it really does look like you're encountering a widely-experienced problem.

21.3k3 gold badges38 silver badges53 bronze badges

Microsoft Access 2007 In Vb6 Runtime Download

I have discovered another issue that I had in the code. On top of the PDF issue answered by Mr. Fenton, I had an issue with the multiple email addresses in the code. I had listed multiple email addresses in the CC portion of the code. If I just list 1 email address, it works.

Microsoft Access Runtime Download

So now I just have to figure out how to send the email to multiple address and all should be well.