Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
avkravi
Starting Member
8 Posts |
 Posted - 2005-11-15 : 18:07:06
|
| Hi,I have created a MS Access Database and pushing in some tables from SQL Server Database through DTS package. The reason is that the client needs the data in MS Access format.Every thing is perfect but when I'm deleting the records in the Access database (.mdb) file, the file is not getting compacted to the original size i.e., the initial size of the .mdb file is 140 KB and after the first set of data is pushed it is 2.1MB and before the next set of data is pushed, I'm deleting the records from the .mdb database tables. The records are getting deleted from the tables, but the file size remains the same i.e., 2.1MBCan anyone out there help me give a solution for my problem.Thanks in advance. |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
|
|
|
|
|
MS Access Database File Size