how to synchronise table size in access db

Question

User149956399 posted

hi friends,

In sqlserver Database Table we have 1,00,000 rows.When we delete all rows the size of the table is decreased or not???

If we want to decrease the size of the table is there any way to synchronize table size or any other ways??

Please give your sugessions

Answer 1

User1283497924 posted

Hi,

check the link

http://stackoverflow.com/questions/442915/what-is-the-best-way-to-synchronize-data-between-ms-access-and-mysql

http://forums.asp.net/t/1126100.aspx/1

http://dbconvert.com/convert-access-to-mysql-sync.php

Answer 2

User3866881 posted

Hello prathika：）

1）For deleting all the records，plz use truncate table xxx instead of delete from xxx，which is fast and easy。

2）For compressing the specific tables to minimize the size as much as possible，I think you can have a try this：

http://msdn.microsoft.com/en-us/library/cc280449.aspx

3）As for Access，I think you can use the Compress tool after deleting all the records：

http://office.microsoft.com/en-us/access-help/compact-and-repair-an-access-file-HP005187449.aspx