Table blocks become fragmented in the database file. When records are added and records are deleted from the table, the How many records a block holds depends on how many fields and how much data is in each record. The complete set of records in a Microsoft Jet table is stored by a series of these blocks. This is similar to the way that a typical file system treats data on your The Microsoft Jet Database Engine treats an Access database file as a series of 4096-byte blocks. The following paragraphs describe the process that is used by Microsoft Jet to compact your database. Although there is no formal rule for how frequently you compact your database, we recommend that you
If there areįrequent changes to your database, compact your database more frequently. If the data does not change frequently, you do not have to compact frequently. How frequently you compact your database depends on how much the data changes. Jet Compact Utility is Available in Download Center Not have a copy of Access, you can still compact the database by using the JetComp utility.įor more information about how to obtain the JetComp Utility for Microsoft Jet 4.0, visit Microsoft's Therefore, periodically run the Compact Database utility in Access. If you make frequent changes to your database, parts of the database may become fragmented. Therefore, must use the older format and use the This is because older Jet engines cannot read or cannot write to a newer Jet database file format. In certain situations, such as when you have both older Jet applications and newer Jet applications that share the same database file, you may not be able to use the latest MDAC 2.6 and later versions do not include the Microsoft Access ODBC driver at all. The Microsoft Access ODBC driver that is included with MDACĢ.1 and MDAC 2.5 uses Microsoft Jet 4.0. Note: The Microsoft Access ODBC driver that is included with MDAC 2.0 or earlier uses Microsoft Jet 3.5.
0 kommentar(er)
