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
You have to compress the database. I can not remember how to do it from C++, but it's possible to do through ADO... - Anders Money talks, but all mine ever says is "Goodbye!"