Groups | Search | Server Info | Login | Register

Groups > comp.databases.ms-access > #767

Re: Finding hidden objects in Access 2003

Show all headers | View raw

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@oilandvinegar.com>
wrote:

>Arsene@selenium.net wrote:
>
>> 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@earthlink.net> wrote:
>> 
>> 
>>><Arsene@selenium.net> wrote in message 
>>>news:moubp6pc0u03ioeblep9f1altcqqi72p7g@4ax.com...
>>>
>>>>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
>>>
>>>I do not know if this reveals all hidden objects or not, but try:
>>>
>>>Tools > Options > View tab >  Select chec box for Hidden Objects 
>>>
>
>Maybe this link might help along with what Charles said.
>http://www.everythingaccess.com/tutorials.asp?ID=Dump-table-details-in-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.
>
>
>

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Find similar

Thread

Finding hidden objects in Access 2003 Arsene@selenium.net - 2011-04-01 11:20 -0500
  Re: Finding hidden objects in Access 2003 "Charles Hottel" <chottel@earthlink.net> - 2011-04-01 14:26 -0400
    Re: Finding hidden objects in Access 2003 Arsene@selenium.net - 2011-04-01 13:42 -0500
      Re: Finding hidden objects in Access 2003 Salad <salad@oilandvinegar.com> - 2011-04-01 19:10 -0500
        Re: Finding hidden objects in Access 2003 Arsene@selenium.net - 2011-04-02 10:02 -0500

csiph-web