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

Thanks.

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Jaisol" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I would like to know if access 97 compact process includes database
>reindex.
>
> Thanks.
>

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]" <(E-Mail Removed)> wrote in message
news:eB%(E-Mail Removed)...
> 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.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
> "Jaisol" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>I would like to know if access 97 compact process includes database
>>reindex.
>>
>> Thanks.
>>
>
>

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

"Jaisol" <(E-Mail Removed)> wrote in message
news:ON$(E-Mail Removed)...
> 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]" <(E-Mail Removed)> wrote in message
> news:eB%(E-Mail Removed)...
>> 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.
>> --
>> Arvin Meyer, MCP, MVP
>> http://www.datastrat.com
>> http://www.mvps.org/access
>> http://www.accessmvp.com
>>
>> "Jaisol" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>>I would like to know if access 97 compact process includes database
>>>reindex.
>>>
>>> Thanks.
>>>
>>
>>
>
>