The Jet Data Manager allows one to control table compression for an individual table and its indexes.
Right click the table → Advanced → Advanced Settings.
The Table Settings dialog will open.
You can create compression on the Raw (_R), Valid (_V), or both variants of the table. You can create the following types of compression for either variant.
- None for no compression
- Row for row level compression
- Page for page level compression
You can read more about individual compression types here: Index Compression Types
If desired, choose Compress Indexes. If checked, the Jet Data Manager will apply compression to indexes on the table as well.