What is the best EntryID format to set on MS Access table

Juliano

Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
I am developing an Access database where I will save information from Outlook to one Access table.
Basically I will save the following data:
  • EntryID
  • StoreID
  • ReceivedTime
  • Subject
  • Sender
I would like to know what is the format for EntryID and StoreID?

Luthius
 

Juliano

Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
Understood. In this case, due the size of the field the best option I guess is to set as a Memo field.

StoreID =472 Characters
EntryID =140 Characters

And also I don't know if the quantity varies.
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Yes, the length of the IDs vary. And afaik there´s no limit.
 
Top