Collecting data in MS Outlook

[David]

Hi,
I try to collect data through MS Outlook 2007 in HTML format. In the wizard
I switched on the option automatically process replies. Unfortunately I
always get an error message that I have no permission to add data into MS
Access database despite the fact I'm owner of the database and I'm a member
of the admin group. The replies are filled in correctly. The database uses
user-level security and is in MS Access 2003 format, but of course I have
installed MS Access 2007 on my computer. The database isn't open exclusively.
If I try to export data manually, the same error message occurs.
Any help would be appreciated.
David

 

[Gina Whipp]

David,

Does any other code run? Have a look at
http://www.regina-whipp.com/index_files/TrustedLocation.htm

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[David]

Hi Gina,
thank you for your answer. I forgot to mention in my first post the Access
database is in trusted location, so the problem is elsewhere. What I don't
understand is how Access knows that that's me who is approaching the database
during export from Outlook, because I can't log any user name or password.
Thank you for your help.
David

 

[Gina Whipp]

David,

It's not personal, but if you are logging in, it knows it's you. Let's look
at some other things...

1. Can you get a look at the References? You are using MDB format with
Outlook 2007 and there might be some confusion there on Access' part.

2. Can you add data the *old fashion way* by simply typing it into the
table?

3. Have you tried exporting as another User?

4. Also, you say export but then you say add to an Access table. Where are
you exporting from? Where are you importing to? If you are exporting from
Outlook to Access, is Access open?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[David]

Hi Gina,
It's not personal, but there was a misunderstanding. Of course if I am
logging in, Access knows who it is. But I think it's irrelevant in this case.
I think I can be logged in as another user, the database can be closed or
even Access can be closed and automated export from Outlook should run. On
the other side it is an attempt to add data into the database, so Access
should know, if the procedure is authorized or not. There is an automatically
generated text in the subject of the e-mail. In my case it is
AccessDataCollection:{D0856DAB-6BC9-4C9B-97C1-C8F92A758F27}. I think there is
an information implemented in this text who created the e-mail message and
therefore you don't need to log in. But maybe I'm wrong.

Here are my answers to your questions:

1. Excluding the two mandatory references, here is a list of my libraries in
descending priority:
- OLE Automation
- MS ActiveX Data Objects 2.1 Library
- MS MAPI Controls 6.0
- MS ADO Ext. 6.0 for DDL and Security
- MS Office 12.0 Object Library
- MS Office Web Components 11.0
- MS DAO 3.6 Object Library

Every library seems to be OK. I tried to change MS ActiveX Data Objects 2.1
Library into MS ActiveX Data Objects 6.0 Library and also to add MS Outlook
12.0 Object Library, but the same error occured. It's logical, because
collecting data in Outlook doesn't run through OLE Automation, but through
XML.

2. Yes, I can add the data manually.

3. No, I haven't tried, but I think it's irrelevant for me, because I want
to be a person who will control collecting data process. The second reason is
nobody else in our company has admin permission. When I was testing the
procedure, I sent the e-mail to myself, then replied, filled in the form and
sent the e-mail back to me. I have also tried to send the e-mail to my
colleague. He replied, filled in the form and sent it to me. The same error
occured. I think it's logical because both e-mails arrived in the same folder.

4. I want to carry out a survey how the auditees are satisfied with the
auditors. I have a table called tblIASatisfaction in my database. I created
the e-mail based on this table. So the users will only add new records into
this table. The procedure should run through Outlook. I tried both
possibilities - Access open and Access closed - with no success.

Here are my two additional comments:

5. The application is digitally signed.

6. When I'm changing VBA code and simultaneously I'm trying to export the
data from Outlook manually, the following error message occurs:
The user David brought in the database into the state which disables opening
or locking the database.

Thank you very much for your interest.
David

 

[Gina Whipp]

David,

Before we go any further, you need to read this page, especially at the
bottom...

http://www.regina-whipp.com/index_files/References.htm

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[David]

Hi Gina,
Thank you for your suggestion. I read your article and removed Microsoft
Office Web Components library from my VBA code. Unfortunately I couldn't
compile my code because I manipulate with pivot table object.

Anyway the problem was solved meanwhile by Arvin Meyer. Simultaneously I
posted my question with the same subject in Security section. Sorry but at
the beginning nobody answered. The problem is Access supports this new
feature only in 2007 format. I used my database in 2003 format. While
converting my database to Access 2007 format, I encountered another problem.
If you are still interested in and want to help me, please look at Security
section. I don't want to be seemed lazy but I think it's useless to describe
the problem twice.
Otherwise thank you very much for your cooperation.

David

 

[Gina Whipp]

David,

I am gald you got an answer and *more* glad (how's that for grammer) that
you posted your solution. If I have time I will venture over to security
and no worries, I wouldn't want you to type your question twice.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm