Rebuilding Table Indexes

J

Joe K.

I have a MS-Access database that has 20 tables. Each table has several
indexes.
Is there away to rebuild like SQL Server?

Please help me with this task.
 
A

Arvin Meyer [MVP]

You can use VBA code or DDL queries (just like in SQL-Server) to drop and
recreate indexes. There is usually no advantage to that because compacting
rewrites everything anyway.

The only time it is really advantages to drop and rebuild indexes is when
there are very large amounts of data to append to a table. Dropping the
index allows the import to go much faster.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Too Many Indexes Bug 5
Exporting query to table in external database 4
Losing Table Index 3
Optimizing Access db running over a network 15
Can a new index on Sql Server 2000 table break existing linked tab 6
Too many indexes warning on table import 5
Linked Table Issue to Oracle 1
Northwind Mystery 20

Top