Records and indexing.

[Guest]

My experience with MS Access is that after adding and deleting records in a
database, the tables must be repaired and reindexed. Have you had to repair
and reindex Access tables remotely and did you encounter any issues?

TIA!

Julie

 

[Douglas J. Steele]

I have never heard of any such requirement in all the years with which I've
been working with Access.

 

[John W. Vinson]

My experience with MS Access is that after adding and deleting records in a
database, the tables must be repaired and reindexed. Have you had to repair
and reindex Access tables remotely and did you encounter any issues?

TIA!

Julie

What do you mean by "remotely"? It's pretty routine to use Citrix or another
terminal server to connect remotely to a database; or are you trying to link a
frontend to a backend over the internet?

John W. Vinson [MVP]

 

[Guest]

My experience with MS Access is that after adding and deleting records in a
database, the tables must be repaired and reindexed. Have you had to repair
and reindex Access tables remotely and did you encounter any issues?

TIA!

Julie

It's not required but you should do it regularly.

 

[Douglas J. Steele]

It's not required but you should do it regularly.

Do what regularly? I agree that compacting (which also repairs) on a regular
basis is a good idea, but there should be no need to reindex the tables (nor
is there any way in Access to reindex, other than deleting the existing
indexes and recreating them)

 

[Paul Shapiro]

I thought compacting rebuilds the indexes?

Do what regularly? I agree that compacting (which also repairs) on a
regular basis is a good idea, but there should be no need to reindex the
tables (nor is there any way in Access to reindex, other than deleting the
existing indexes and recreating them)