Access 97 compact process

[Jaisol]

I would like to know if access 97 compact process includes database reindex.

Thanks.

 

[Arvin Meyer [MVP]]

All database compacts (or pack, or whatever they call them in each version)
do re-indexing as far as I know. Access definitely re-indexes it's files.
Keep in mind that it will not change the index number if the index is a key,
but it will reorder based upon that key or another indexed field. Therefore
if you use an alpha index on a field in a table with a autonumbered key, it
will re-index to the alpha field.

 

[Jaisol]

Clear.

May be you can help with something else.
We will compact local access database through code on many w2k machines and
we don't know exactly the OLEDB Jet provider installed on each.
How can we know what OLEDB Jet Provider is installed?

Thks.

 

[Arvin Meyer [MVP]]

Knowing the OLEDB Jet Provider isn't necessary to compact a database.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com