How do a find the size of an embedded document in an access table

[Guest]

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.

 

[Arvin Meyer [MVP]]

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

 

[Guest]

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

 

[Stephen Lebans]

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.

 

[Guest]

Thanks Stephen,
I'll give it whirl.

CS-Melb

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.

 

[Bob Quintal]

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.