Senin, 03 Oktober 2016

Re: [MS_AccessPros] Attachment field question


Hi Jim,

it depends on how many attachments you have.  And yes, it does make the database bigger.  Another problem with attachments is that often the same file is duplicated in the database (well probably not pictures of employees, but I found only 30% unique files for reference documents in one of the databases I analyzed and took attachments out of) whereas if it was referencing an external file, it would just be another text field with the path and filename.

I generally create a directory below the back-end with all the referenced files so it is easy to move them along with the database and everyone can get the same file even if their paths are different.


~ have an awesome day ~

On 10/3/2016 4:59 PM, [MS_Access_Professionals] wrote:

Hello all,

I was just given a new project on a database that I did not build. There is an attachment field on the form. I am not very familiar with that. I was always told that it bloats databases. Yet when I tested the process, it looked like the opening of the attached files where looking at a location in a folder.

So the question is, does the attached field bloat the database and make the 2GB limit a quick reach in a very short time?

Thank You

Jim Wagner


Posted by: crystal 8 <>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.



Tidak ada komentar:

Posting Komentar