G
Guest
Do Access files have Metadata like word and Excel do? If it does how do you
clean it.
clean it.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
I
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.
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
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
I
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.
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
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
R
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.
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.
R
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.
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.
6
'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.
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.
6
'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.
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.