How does access database lose weight???

toptime

Now it is like this. I used a loop in vb to insert 80,000 records with different numbers into the table named default in the access database. The database has 122mb.

Then I opened the database with access, created a new one, and dragged the default table to the newly created mdb file, and the result was only 8mb...I think it must be the access database that recorded my 80,000 insert operations...

I beg everyone, how to make the database slim???

lava2411

Use ACCESS's "Compress and Repair Database" function

toptime

Only use the CompactDatabase method to compress the database. Such as:
     DBEngine.CompactDatabase "C:\My Documents\MyDB.mdb", _
     "C:\My Documents\Test.MDB", dbLangGeneral, dbVersion30, _
     ";pwd=MyPassword1"



Which control does this compactdatabase method belong to?

toptime

I found the easiest way...also for your reference...
'Install Microsoft ActiveX Data Objects 2.X library (X is 1 or more)
'Quote Microsoft Jet and Replication Objects 2.X library
Dim jro As jro.JetEngine
Set jro = New jro.JetEngine
jro.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\test\test.mdb", _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\test\new.mdb;"
'Jet OLEDB:Engine Type=4

Thank you all!