|
|
|
date: Thu, 3 Jul 2008 06:40:02 -0700,
group: microsoft.public.access.externaldata
back
Re: Unique Identifier
I'll admit my ignorance with Outlook, but with linked tables you can't add or
enforce a primary key or unique index. You have to import the data from
Outlook into a table, and then you can assign your own primary key.
Once you import the data, you may be able to create a unique index on
multiple columns: sender, subject, date/time sent, date/time recieved, and
message size. But it's not guaranteed that a sender won't send two messages
with the same subject and byte size at the same time (to the second) and both
messages are received by the recipient at the same time (to the second).
It's only highly unlikely.
You'd have to periodically import new messages from Outlook to add to the
table to keep it up to date.
Chris
Microsoft MVP
Brent wrote:
>Hi folks,
>
>I'm not sure if this is the right category; I am linking a specific folder
>from Outllook into Microsoft Access. The db I'm using is to keep track of
>staff inquiries and I have linked a folder from Outllook to the db so that I
>can keep notes on the inquires as they come in by e-mail. What I need from
>Outlook is the ability to show the unique identifier in the linked table. I
>know how to put it on the form, however I can't seem to publish that form in
>the correct folder. Secondly I'm not sure that would work. If I alter a form
>to reflect the unique identifier, will it show on the linked table in Access.
>If I can do that I can do the rest in Access.
>
>Alternaitivly, if anyone has a suggestion on how to make an e-mail unique,
>that would be appreciated too!
>
>Thanks,
>
>Brent
>
>...but its summer holidays, I shouldn''t be learning!
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200807/1
date: Thu, 03 Jul 2008 17:28:24 GMT
author: Chris O'C via AccessMonster.com u29189@uwe
Re: Unique Identifier
check out the EntryID property in the outlook items
initially it seems to be about a 40 character alphanumeric code which
outlook uses to identify the item (it can be an appointment, task, email
etc.). I have found with email using exchange that the EntryID can be a lot
larger. Anyhow do some browsing on that property
"Pete D." wrote in message
news:qcqbk.11811$Fj5.6058@newsfe23.lga...
> You might post in the MS Outlook newsgroup as exposing what you need in
> outlook will probally be your biggest challange.
> This page might help you get started. Duff
> http://www.outlookcode.com/article.aspx?id=25
>
>
>
> "Brent" wrote in message
> news:D483EA24-03A9-4832-AAA9-B2429D16B7B4@microsoft.com...
>> Hi folks,
>>
>> I'm not sure if this is the right category; I am linking a specific
>> folder
>> from Outllook into Microsoft Access. The db I'm using is to keep track of
>> staff inquiries and I have linked a folder from Outllook to the db so
>> that I
>> can keep notes on the inquires as they come in by e-mail. What I need
>> from
>> Outlook is the ability to show the unique identifier in the linked table.
>> I
>> know how to put it on the form, however I can't seem to publish that form
>> in
>> the correct folder. Secondly I'm not sure that would work. If I alter a
>> form
>> to reflect the unique identifier, will it show on the linked table in
>> Access.
>> If I can do that I can do the rest in Access.
>>
>> Alternaitivly, if anyone has a suggestion on how to make an e-mail
>> unique,
>> that would be appreciated too!
>>
>> Thanks,
>>
>> Brent
>>
>> ...but its summer holidays, I shouldn''t be learning!
>
>
date: Tue, 8 Jul 2008 13:47:40 +1000
author: wphx
|
|
