Database size problem.
-
Hi All, I have a query regarding MS Access Database.I am creating a Database & a table in it .I add the Records to the table.The size of teh Database mdb file is increasing as I add the record.But, when I deleted all the REcords in the table in Database, the size of the Database remained the same(as before deletion of REcords).Why is it so ?I am using ADOX to add the Records & the same to delete the Records . How can I overcome this problem ? Does in MS Access the size of Database decrease on deletion of Records if any ?If so how it can be done ? YAMINI
-
Hi All, I have a query regarding MS Access Database.I am creating a Database & a table in it .I add the Records to the table.The size of teh Database mdb file is increasing as I add the record.But, when I deleted all the REcords in the table in Database, the size of the Database remained the same(as before deletion of REcords).Why is it so ?I am using ADOX to add the Records & the same to delete the Records . How can I overcome this problem ? Does in MS Access the size of Database decrease on deletion of Records if any ?If so how it can be done ? YAMINI