|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
May 24th, 2007, 07:53 AM
|
|||
|
|||
How To Reduse the size of ms access database
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????
|
|
#2
May 24th, 2007, 09:14 AM
|
||||
|
||||
|
Open up msaccess (just msaccess... dont open a db)
On the tools menu you will find a compact/repair database option. It will ask you to choose the DB you want to compact.
__________________
A wise man remembers his friends at all times; a fool, only when he has need of them 
|
|
#3
May 26th, 2007, 05:58 PM
|
|||
|
|||
|
Also, google should turn up examples on running a compact & repair from code if you want to try that route.
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
|
|
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > How To Reduse the size of ms access database |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
