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

Insert Index into a Table 1
Help creating a search form in Access XP 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Error-17099 SMTP Relay Error Problem Entourage 2004 0
Project Server 2007 SP2: Gantt with data in OLAP but not in Published or Draft Databases 0
maximum number of indexes per SQL table that Access (jet) can dealwith? 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Database badly damaged 0

Top