Compacting database

[Nath]

Hi All,

I am using 1 access database to open several databases and
inmport the data from thier tables. However, after i have
done this import i wish to compact the database.

I have set up a DATABASE object to do this as after the
import i need to run a bit of SQL on the look up tables
within the Database. The database object is DBS.

How can i make DBS compact after the import.

eg. dbs.?????????

Cheers

Nathan.

 

[Roger Carlson]

On my website is a small sample database called "CompactDatabase.mdb", which
shows you one way to do this.

 

[???]

Hi All,

I am using 1 access database to open several databases and
inmport the data from thier tables. However, after i have
done this import i wish to compact the database.

I have set up a DATABASE object to do this as after the
import i need to run a bit of SQL on the look up tables
within the Database. The database object is DBS.

How can i make DBS compact after the import.

eg. dbs.?????????

Cheers

Nathan.