how to synchronise table size in access db RSS

• • Reply
  

  prathika

  Member

  65 Points

  112 Posts

  how to synchronise table size in access db

  Feb 28, 2012 06:44 AM|LINK

  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

  access 2007

• • Reply
  

  vinay13mar

  Star

  7778 Points

  1632 Posts

  Re: how to synchronise table size in access db

  Feb 28, 2012 06:47 AM|LINK

  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

  Thanks
  V.K.Singh
  
  
  
• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: how to synchronise table size in access db

  Mar 01, 2012 12:33 AM|LINK

  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

  • Edited by decker dong - msft on Mar 01, 2012 12:36 AM
  • Marked as answer by decker dong - msft on Mar 05, 2012 12:40 AM