Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How to clean Metadata from Access

Discussion in 'Information Technology' started by aware, Jul 28, 2006.

  1. aware

    aware
    Expand Collapse
    Guest

    Do Access files have Metadata like word and Excel do? If it does how do you
    clean it.
     
  2. Loading...


  3. Immanuel Sibero

    Immanuel Sibero
    Expand Collapse
    Guest

    Hi Aware,

    Hmm.. Interesting question.. makes me wonder why you're asking it.
    Yes Access has lots of metadata. Also, how much metadata in it depends on
    your definition of metadata.

    > If it does how do you
    > clean it.


    I guess you can export to other data formats (i.e. comma delimited, tab
    delimited, etc)? You could export to Excel. This would strip Access'
    metadata but then again as you have indicated in your post, Excel in turn
    will put in its own metadata.


    Immanuel Sibero


    "aware" <aware@discussions.microsoft.com> wrote in message
    news:E4274766-3D8B-44D5-A38C-36CEA2C1CA14@microsoft.com...
    > Do Access files have Metadata like word and Excel do? If it does how do

    you
    > clean it.
     
  4. Rick Wannall

    Rick Wannall
    Expand Collapse
    Guest

    The only "cleaning" you can do is the compact/repair operation. That
    removes deleted objects and release space back to the file system.

    Even if you COULD remove metadata (and Access has tons) why would you WANT
    to? It's all used to manage the objects you create and use for data entry,
    retrieval, formatting, etc. Without the metadata, you don't have Access
    objects anymore, just a lot of bits, like any file.

    "aware" <aware@discussions.microsoft.com> wrote in message
    news:E4274766-3D8B-44D5-A38C-36CEA2C1CA14@microsoft.com...
    > Do Access files have Metadata like word and Excel do? If it does how do
    > you
    > clean it.
     
  5. '69 Camaro

    '69 Camaro
    Expand Collapse
    Guest

    Hi.

    If you're referring to the personal and hidden metadata in MS Office 2003
    applications, then yes, Access contains some of this metadata, too, but the
    metadata cleanup tool doesn't work with Access. You'll have to remove the
    information manually from "Summary" tab in the Database Properties window.

    HTH.
    Gunny

    See http://www.QBuilt.com for all your database needs.
    See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
    http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
    info.


    "aware" <aware@discussions.microsoft.com> wrote in message
    news:E4274766-3D8B-44D5-A38C-36CEA2C1CA14@microsoft.com...
    > Do Access files have Metadata like word and Excel do? If it does how do
    > you
    > clean it.
     

Share This Page