Welcome to SPN

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

Sign Up Now!
  1. Guest ji, please consider donating today!
      Become a Supporter    ::   Make a Contribution   
    Monthly Recurring Target: $300 :: Achieved: $95

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.
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page