How to clean Metadata from Access

[Guest]

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

 

[Immanuel Sibero]

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

 

[Immanuel Sibero]

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

 

[Rick Wannall]

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.

 

[Rick Wannall]

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.

 

['69 Camaro]

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.

 

['69 Camaro]

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.