Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

File Size

Status
Not open for further replies.
sflau

sflau

Programmer
Oct 18, 2001
87
0
0
HK
I am using MS Access 2000.

I find that the Access File size is too large, so that I delete some out of date records.

But I find that the size is still the same as before. Can anyone tell me why?

How to decrease the size after delete the unless records, please?

Thank you.
 
Sort by date Sort by votes
Hi,
Go to Tools Menu
>Database Utilities
>Compact and Repair Database.
This will help

ZmrAbdulla
 
Upvote 0 Downvote
It works, thank you so much.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MattGreer
  • Locked
  • Question
Added Buttons - Form Size Changed
Replies
0
Views
25
MattGreer
MattGreer
cimoli
  • Locked
  • Question
ZOOM box crashes my Access file. 1
Replies
2
Views
61
cimoli
cimoli
lmcate
  • Locked
  • Question
.laccdb file will not close on the server when I close the program???
Replies
1
Views
114
Andrzejek
Andrzejek
Triacona
  • Locked
  • Question
how to make access open in read-only mode using vb to stop the .laccdb file 1
Replies
4
Views
90
Triacona
Triacona
cimoli
  • Locked
  • Question
Opening the same file twice on the same computer.
Replies
5
Views
79
cimoli
cimoli

Part and Inventory Search

Sponsor

Back
Top