What do recovery and CD operations with .MDB do? Will they stop the application crashing?

Question

What do repair and compact operations .MDBdo?

If these operations do not stop a VB application that supports 1 GB + .MDB, what other options exist?

Why .MDBdoes a large file cause the application to crash?

Answer 1

"What do compact and repair operations with MDB do?"

-, . , , , . , Jet 3.51, . , , Jet/ACE , . , , .

, ?

/ , , QueryDefs . .

"" , . , , , . , Jet/ACE, , , . , , . , , , .

. ( Jet/ACE , , ). , .

Compact - , Jet/ACE, . , , , / . , , .

, MDB/ACCDB, .

, , front-end bload - - , . MDB/ACCDB, VB, , , - , , . , .

Answer 2

, MDB , 1 , , - . , - , , MDB, , MDB 1 .

MS KB , , :

http://support.microsoft.com/kb/209769/EN-US/

, , / , MDB, - , , ? , , .

Answer 3

, / .

, /decompile ,

"C:\Program Files\access\access.mdb" "C:\mydb.mdb" /

, ,

EDIT:

, , . , , jetcomp, .

support.microsoft.com/kb/273956