Why size of database is not changing after deleting all records

bawa_jain

New member
Local time
Today, 01:18
Joined
May 24, 2007
Messages
1
I had made a software in vb having database in ms access.I entered thousands of records in that database.But when i delete records form the the database by query:
"Delete from tbtemp" (tb temp is the tablename) then it delete the records from database BUT IT DOES NOT REDUSE THE SIZE OF DATABASE.
Plz tell me why the the size of database is not changing after deleting all records from database????
 
You have to compact the database to reduce its size.
Tools - Database Utilities - Compact and Repair


Brian
 

Users who are viewing this thread

Back
Top Bottom