Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / February 2006

Tip: Looking for answers? Try searching our database.

Problem with Outlook 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Peter Adema - 31 Jan 2006 11:19 GMT
Our IT department installed Outlook 2003 on my new laptop.
From that moment I cannon send mails via a macro in Access anymore.
It was working with Outlook 2000.
When I am in the Visual Basic screen and want to Debug, the next error
appears:
MS Access encountered a problem and has to be closed.
When I click on the details I see:
Appname:MSAccess.exe
Appver:90.0.3822  Modname VBe6.dll
Modver: 64.99.72  offset:0009792f

I presume I miss a dll file somewhere.
In the Visual Basic code I use this way of sending automatic E-mails in
Outlook.

Dim objolk As Outlook.Application
Dim objMailItem As Outlook.MailItem
Dim olkNameSpace
Dim signmail As String
Set objolk = New Outlook.Application
Set olkNameSpace = objolk.GetNamespace("MAPI")
Set objMailItem = objolk.CreateItem(olMailItem
Tim Ferguson - 31 Jan 2006 18:03 GMT
"=?Utf-8?B?UGV0ZXIgQWRlbWE=?=" <PeterAdema@discussions.microsoft.com> wrote
in news:6596DA7C-84BE-4568-8850-99F19C2466BF@microsoft.com:

> Our IT department installed Outlook 2003 on my new laptop.
> From that moment I cannon send mails via a macro in Access anymore.

Either you have to have a digital ID certificate (can be expensive!) or you
drop the users' security level. Considering this is Outlook we are talking
about, I really would not recommend the second one!

Sorry.

Tim F
Peter Adema - 01 Feb 2006 12:39 GMT
Hello Tim,
Thanks for your anwer, but I do not really understand it.
How can there be a security issue if I only Debug an existing Visual Basic
routine in Access?
Are you sure the solution you gave is the right one?

Greetings Peter.

> "=?Utf-8?B?UGV0ZXIgQWRlbWE=?=" <PeterAdema@discussions.microsoft.com> wrote
> in news:6596DA7C-84BE-4568-8850-99F19C2466BF@microsoft.com:
[quoted text clipped - 9 lines]
>
> Tim F
Tim Ferguson - 01 Feb 2006 17:21 GMT
"=?Utf-8?B?UGV0ZXIgQWRlbWE=?=" <PeterAdema@discussions.microsoft.com>
wrote in news:A0FE32D7-F932-4B41-907D-68E7E90D1642@microsoft.com:

> Are you sure the solution you gave is the right one?

Actually, I realised it wasn't about one minute after I pressed the
<send> key... I went straight into the FAQ "I can't program Outlook any
more because of the security" and read the rest of your message later.
Sorry :-(

Back with your original message, I don't think I have very much to offer.
I would suspect a mdb corruption or a broken outlook installation, or
else a DLL-hell problem with mixed versions of Office. Try compacting &
repairing the mdb first; after that I can't help.

If you don't get any better answers here, you might try
m.p.outlook.interop or m.p.outlook.program_vba next.

All the best

Tim F
Peter Adema - 02 Feb 2006 15:28 GMT
I have found the problem myself.
I had a reference in VBA  "Microsoft Activex database objects 2.1"
When I unchecked this option, the problem was solved.

> "=?Utf-8?B?UGV0ZXIgQWRlbWE=?=" <PeterAdema@discussions.microsoft.com>
> wrote in news:A0FE32D7-F932-4B41-907D-68E7E90D1642@microsoft.com:
[quoted text clipped - 17 lines]
>
> Tim F
Tim Ferguson - 02 Feb 2006 20:41 GMT
"=?Utf-8?B?UGV0ZXIgQWRlbWE=?=" <PeterAdema@discussions.microsoft.com> wrote
in news:6B0C6737-A062-4241-961B-451656C7D63A@microsoft.com:

> I had a reference in VBA  "Microsoft Activex database objects 2.1"
> When I unchecked this option, the problem was solved.

Sounds reasonable; well done.

All the best

Tim F
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.