I inherited this Access application, in which some fields in several
tables are supposed to contain hyperlinks pointing to PDF documents
sitting elsewhere in the network. The original designer appears to
have embedded some of these PDF documents in the database itself, with
the consequent bloat. While persuing through one of the tables, I
found an odd looking character in one of the hyperlink fields, deleted
it, and saw a 5 MB reduction in the size of the database file.

Is there any way to reveal any and all objects that have been hidden
in a Microsoft mdb file?

Thanks

<Arsene (AT) selenium (DOT) net> wrote

I do not know if this reveals all hidden objects or not, but try:

Tools > Options > View tab > Select chec box for Hidden Objects

Thanks for the tip, Charles, however, this does not appear to reveal
embedded objects. It seems to me there should be a way to view such
objects.

Thanks.

On Fri, 1 Apr 2011 14:26:39 -0400, "Charles Hottel"
<chottel (AT) earthlink (DOT) net> wrote:

Arsene (AT) selenium (DOT) net wrote:

Maybe this link might help along with what Charles said.
http://www.everythingaccess.com/tuto...-VBA-%28DAO%29

You could modify the above program to look just for fields that have Ole
Objects. Ex:
Case dbLongBinary: strReturn = "OLE Object" '11
by cuttinng out the all other types of fld.Type in the code. Maybe
return a boolean True if it has an Ole Object, false if none.

Then run a program that loops thru your tables and list out all that
have OleObject field types. I don't think you have to unhide the tables
but maybe.

That approach would likely work, Salad.

It does appear to me, though, that, just like the Access environment
provides the capability to embed objects into the database file, it
should likewise provide the capability to reveal such objects for
inspection and/or removal as needed. Not providing such capability
seems like an odd decision on the part of MS.

Thanks for the tip, I'll see if I can make it work for my particualr
situation.

Arsene


On Fri, 01 Apr 2011 19:10:12 -0500, Salad <salad (AT) oilandvinegar (DOT) com>
wrote: