登入
Microsoft.com
 
Microsoft
 
 
 

none
Why isn't the file size changed when more records is stored in it RRS feed

 > 

  • 問題

  • Question
    登入以投票
    0
    登入以投票

    Hi,

     

    I have an access file which of size is 16,568KB in July and version is 97. I stored more records into it in Aug and Sep and found that its size is the same. Then, I checked records of it and could not find any problem in it. But I want to know why the file size is the same when more records are stored in it. Thank you for your help. If anyone know the reason, I hope I can receive your response as soon as you can.

     

    Tony

    2008年11月26日 上午 08:35
    |

解答

  • Question
    登入以投票
    0
    登入以投票

    If you are referring to "Size on disk" then it is not the actual data size in your mdb file because in most of the time, the content may not fill up all space in each sector on your hard disk.  In addition, depending on the method you access your data file (e.g. Jet Database Engine), there may be 64KByte pre-allocated space in your data file (ref: http://technet.microsoft.com/en-us/library/cc767939.aspx).

    2008年12月2日 下午 03:02
    |

所有回覆

  • Question
    登入以投票
    0
    登入以投票
    Are you referring to "Size" of "Size on disk"?  In addition, in most of the database files, there may be some pre-allocated disk space to them in order to minimize I/O when performing insertion or modification.

     

    2008年11月30日 下午 04:30
    |
  • Question
    登入以投票
    0
    登入以投票

    Hi Raymond Yuen,

     

    First, thank you for your response and help. Yes, I am referring to this "Size" of "Size on disk". Can you provide more information about pre-allocated disk space...to me ? For your understanding this case more, I want to tell you more.  I backup my data file monthly so I have the copy of file in the different month. I tried to convert these files in June and Sep into version 2000 and then I found that their sizes are not the same. Finally, thank you once again. I hope I can receive your response again soon.

     

    Tony Carfield

    2008年12月1日 上午 08:50
    |
  • Question
    登入以投票
    0
    登入以投票

    If you are referring to "Size on disk" then it is not the actual data size in your mdb file because in most of the time, the content may not fill up all space in each sector on your hard disk.  In addition, depending on the method you access your data file (e.g. Jet Database Engine), there may be 64KByte pre-allocated space in your data file (ref: http://technet.microsoft.com/en-us/library/cc767939.aspx).

    2008年12月2日 下午 03:02
    |
  • Question
    登入以投票
    0
    登入以投票

    Thank you for your providing helpful information to me.

     

    Tony Carfield

     

    2008年12月5日 上午 04:51
    |