Records and indexing.

J

jjacob

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
 
D

Douglas J. Steele

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

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
Click to expand...

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]
 
R

rick

jjacob said:
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
Click to expand...

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

Douglas J. Steele

rick said:
It's not required but you should do it regularly.
Click to expand...

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)
 
P

Paul Shapiro

I thought compacting rebuilds the indexes?

Douglas J. Steele said:
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)
Click to expand...
 
Top