Why should I care about compressing the MS Access.mdb file?

Question

We are distributing an application that uses the MS Access.mdb file. Someone noticed that after opening a file in MS Access, the file size is greatly reduced. This suggests that the file is a good candidate for compression, but we do not provide tools for our users.

So my question is: does it matter? Do we care? What can happen if our users never compress the database?

Answer 1

In addition to shrinking your database, it will recount the indexes in your tables and defragment your tables, which can make access faster. It will also find any inconsistencies that should never occur in your database, but can be caused by errors or failures in Access.

This is not entirely risk-free, although an error in Access 2007 sometimes deleted your database during the process.

So this is generally a good thing, but you need to make a couple with a good backup routine. Thanks to the backup, you can also restore any "fatal" compact and repair problems with minimal data loss.

Answer 2

, , , . , - - , . , , , , - .

Jet , 4 "" (2 95/97) , , , . Jet , , , , . / db.

Jet . , Jet , , . , Jet , , .

2000, 2002, 2003 2007 , . :

1 -

2 - ,

3 - , ( "" , Access)

4 - VBA

5 - , ,

6 - , ​​

, , / db, , - , - , .

Answer 3

Access ( MS JET) . (, , MS JET) - , , , - .

, [Access] (, ), - ( , , ).

, ():

• , ( ).
• ( ).
• Access, , , , , . ( Access , .)

Microsoft Access ADO , .

Answer 4

. , 600 , 60-80.

Answer 5

Nate: , . , . , , , , ( , ).

, , , MS-SQL.

Answer 6

, .

Answer 7

, Access . .

Answer 8

, ! mdb , , . . mdb, , :

Application.SetOption( "" ), 1

Answer 9

I also highly recommend looking into VistaDB ( http://www.vistadb.net/ ) or SQL Compact ( http://www.microsoft.com/sql/editions/compact/ ) for your application. This may not be suitable for your application ... but they deserve attention.