Bill, as a digression, you mean to say that one field in one record can hold 1 gigabyte but the full database size limit is still 2 gigabytes?
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, October 05, 2015 7:13 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Linking to Outlook folder - message truncated
Ray - According to MS Office support:
Text fields in desktop databases (.accdb)
Long Text In .accdb files, the Long Text field works the same as the Memo field of old. That is, it can store up to about a gigabyte of text, even though controls on forms and reports can only display the first 64,000 characters. You can set Long Text fields to display Rich Text, which includes formatting like bold and underline.
But that doesn't say anything about what you can see by viewing the field directly in the linked table. Have you tried opening the table and looking at the data?
Regards,
Bill Mosca, Founder - MS_Access_Professionals
Microsoft Office Access MVP
My nothing-to-do-with-Access blog
http:/! /wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <rayfrew@gmail.com> wrote :
Hi everyone
I'm trying to link my database to Outlook so that as emails arrive I can use them in Access. I followed the wizard (External Data / More / Outlook folder) and chose the option to "Link" and create a linked table. That worked fine. However, I noticed that the contents of the email is truncated. When I looked at the linked table created the data type is "Long Text" - is that significant?
If I had chosen the first option from the wizard which "Imports the source data" I get all of the email.
It seems as though I can have (1) linked tables showing up to date "partial" emails or (2) all of the email, ! just not up to date (I would have to refresh the table on a regular basis). Is there a way I can have all of the email and a true, up to date link to my Outlook system? I'm using Outlook 2013 and Access 2013.
Any ideas / pointers much appreciated.
Many thanks
Ray
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar