I have been given an access table to manage, which holds MS Word documents.
The Table has started to get very big very fast. I want to find which
documents are creating the problem. Is there a was in Access to display the
Document size in bytes, kn or mb and then find and sort on these.
The Table format is quite simple, ID, Name of Doc, Document (Long Binary)
and a date/time stamp. But in the past 2 months its doubled in size even
after compression. We have used it for 2 years and it stayed fairly small.
I want to find the documents that are doing this and see if we adjust.

All of the documents are creating the problem. Instead of embedding and
storing the documents within the database, store the path to them on a
server or hard drive. An free app to do that is on my website:

http://www.datastrat.com/Download/DocMgr_2K.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"CS-Melb" <CS-(E-Mail Removed)> wrote in message
news:3880C4F5-0C96-4FBC-8C7B-(E-Mail Removed)...
>I have been given an access table to manage, which holds MS Word documents.
> The Table has started to get very big very fast. I want to find which
> documents are creating the problem. Is there a was in Access to display
> the
> Document size in bytes, kn or mb and then find and sort on these.
> The Table format is quite simple, ID, Name of Doc, Document (Long Binary)
> and a date/time stamp. But in the past 2 months its doubled in size even
> after compression. We have used it for 2 years and it stayed fairly small.
> I want to find the documents that are doing this and see if we adjust.

Thanks Arvin,
Unfortunately that's a very long term solution. The Database application
was not written by me and I do not have the code behind it, and its a run
time. The Guy who built it left and seems to have dropped off the planet.
I'm left with one table (of many) that hold all the Word docs.
I forgot mention the table is in Access 97 format. Again can't do much
about it until we have 12 months to redesign and build it.

CS-Melb


"Arvin Meyer [MVP]" wrote:

> All of the documents are creating the problem. Instead of embedding and
> storing the documents within the database, store the path to them on a
> server or hard drive. An free app to do that is on my website:
>
> http://www.datastrat.com/Download/DocMgr_2K.zip
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
> "CS-Melb" <CS-(E-Mail Removed)> wrote in message
> news:3880C4F5-0C96-4FBC-8C7B-(E-Mail Removed)...
> >I have been given an access table to manage, which holds MS Word documents.
> > The Table has started to get very big very fast. I want to find which
> > documents are creating the problem. Is there a was in Access to display
> > the
> > Document size in bytes, kn or mb and then find and sort on these.
> > The Table format is quite simple, ID, Name of Doc, Document (Long Binary)
> > and a date/time stamp. But in the past 2 months its doubled in size even
> > after compression. We have used it for 2 years and it stayed fairly small.
> > I want to find the documents that are doing this and see if we adjust.
>
>
>

Add an OLE Frame control to a form bound to the table in question. Loop
through all of the records and take the LenB of the Value prop of a Bound
OLE Frame control. Any document containing Images is likely the suspect(s).

You can export the contents of the field to disk. See:
htttp://www.lebans.com/oletodisk.htm
NEW - Feb 06/2006 ExtractInventoryOLE.zip A2K or higher ONLY! This
version saves the entire contents of a table containing OLE Objects to disk.
Does NOT require the original application that served as the OLE server to
insert the object. Supports all MS Office documents, PDF, All images
inserted by MS Photo Editor, MS Paint, and Paint Shop Pro. Also supports
extraction of PACKAGE class including original Filename. Contains function
to produce a full Inventory of the OLE field including LINKED path and
Filenames. Uses Structured Storage API's to read the actual contents of the
field.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"CS-Melb" <(E-Mail Removed)> wrote in message
news:E71C7DA8-0B17-48CD-BEB0-(E-Mail Removed)...
> Thanks Arvin,
> Unfortunately that's a very long term solution. The Database application
> was not written by me and I do not have the code behind it, and its a run
> time. The Guy who built it left and seems to have dropped off the planet.
> I'm left with one table (of many) that hold all the Word docs.
> I forgot mention the table is in Access 97 format. Again can't do much
> about it until we have 12 months to redesign and build it.
>
> CS-Melb
>
>
> "Arvin Meyer [MVP]" wrote:
>
>> All of the documents are creating the problem. Instead of embedding and
>> storing the documents within the database, store the path to them on a
>> server or hard drive. An free app to do that is on my website:
>>
>> http://www.datastrat.com/Download/DocMgr_2K.zip
>> --
>> Arvin Meyer, MCP, MVP
>> http://www.datastrat.com
>> http://www.mvps.org/access
>> http://www.accessmvp.com
>>
>> "CS-Melb" <CS-(E-Mail Removed)> wrote in message
>> news:3880C4F5-0C96-4FBC-8C7B-(E-Mail Removed)...
>> >I have been given an access table to manage, which holds MS Word
>> >documents.
>> > The Table has started to get very big very fast. I want to find which
>> > documents are creating the problem. Is there a was in Access to
>> > display
>> > the
>> > Document size in bytes, kn or mb and then find and sort on these.
>> > The Table format is quite simple, ID, Name of Doc, Document (Long
>> > Binary)
>> > and a date/time stamp. But in the past 2 months its doubled in size
>> > even
>> > after compression. We have used it for 2 years and it stayed fairly
>> > small.
>> > I want to find the documents that are doing this and see if we adjust.
>>
>>
>>

Thanks Stephen,
I'll give it whirl.

CS-Melb

"Stephen Lebans" wrote:

> Add an OLE Frame control to a form bound to the table in question. Loop
> through all of the records and take the LenB of the Value prop of a Bound
> OLE Frame control. Any document containing Images is likely the suspect(s).
>
> You can export the contents of the field to disk. See:
> htttp://www.lebans.com/oletodisk.htm
> NEW - Feb 06/2006 ExtractInventoryOLE.zip A2K or higher ONLY! This
> version saves the entire contents of a table containing OLE Objects to disk.
> Does NOT require the original application that served as the OLE server to
> insert the object. Supports all MS Office documents, PDF, All images
> inserted by MS Photo Editor, MS Paint, and Paint Shop Pro. Also supports
> extraction of PACKAGE class including original Filename. Contains function
> to produce a full Inventory of the OLE field including LINKED path and
> Filenames. Uses Structured Storage API's to read the actual contents of the
> field.
> --
>
> HTH
> Stephen Lebans
> http://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
>
> "CS-Melb" <(E-Mail Removed)> wrote in message
> news:E71C7DA8-0B17-48CD-BEB0-(E-Mail Removed)...
> > Thanks Arvin,
> > Unfortunately that's a very long term solution. The Database application
> > was not written by me and I do not have the code behind it, and its a run
> > time. The Guy who built it left and seems to have dropped off the planet.
> > I'm left with one table (of many) that hold all the Word docs.
> > I forgot mention the table is in Access 97 format. Again can't do much
> > about it until we have 12 months to redesign and build it.
> >
> > CS-Melb
> >
> >
> > "Arvin Meyer [MVP]" wrote:
> >
> >> All of the documents are creating the problem. Instead of embedding and
> >> storing the documents within the database, store the path to them on a
> >> server or hard drive. An free app to do that is on my website:
> >>
> >> http://www.datastrat.com/Download/DocMgr_2K.zip
> >> --
> >> Arvin Meyer, MCP, MVP
> >> http://www.datastrat.com
> >> http://www.mvps.org/access
> >> http://www.accessmvp.com
> >>
> >> "CS-Melb" <CS-(E-Mail Removed)> wrote in message
> >> news:3880C4F5-0C96-4FBC-8C7B-(E-Mail Removed)...
> >> >I have been given an access table to manage, which holds MS Word
> >> >documents.
> >> > The Table has started to get very big very fast. I want to find which
> >> > documents are creating the problem. Is there a was in Access to
> >> > display
> >> > the
> >> > Document size in bytes, kn or mb and then find and sort on these.
> >> > The Table format is quite simple, ID, Name of Doc, Document (Long
> >> > Binary)
> >> > and a date/time stamp. But in the past 2 months its doubled in size
> >> > even
> >> > after compression. We have used it for 2 years and it stayed fairly
> >> > small.
> >> > I want to find the documents that are doing this and see if we adjust.
> >>
> >>
> >>
>
>
>

"Stephen Lebans"
<ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com> wrote
in news:(E-Mail Removed):

> Add an OLE Frame control to a form bound to the table in
> question. Loop through all of the records and take the LenB of
> the Value prop of a Bound OLE Frame control. Any document
> containing Images is likely the suspect(s).
>
> You can export the contents of the field to disk. See:
> htttp://www.lebans.com/oletodisk.htm
> NEW - Feb 06/2006 ExtractInventoryOLE.zip A2K or higher
> ONLY! This version saves the entire contents of a table
> containing OLE Objects to disk. Does NOT require the original
> application that served as the OLE server to insert the
> object. Supports all MS Office documents, PDF, All images
> inserted by MS Photo Editor, MS Paint, and Paint Shop Pro.
> Also supports extraction of PACKAGE class including original
> Filename. Contains function to produce a full Inventory of the
> OLE field including LINKED path and Filenames. Uses Structured
> Storage API's to read the actual contents of the field.

Stephen, you are a Godsend.

This is just what I need to recover some archival data from rev.
- of a software I wrote several years ago. From rev. 1 the
attachments are stored in a subdirectory on the server not in
the table. But othre than manually exporting a few documents as
needed, those in the original version were unreachable.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com