Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Nov 2003
    Location
    London, Gtr London, England
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access DataBase size on Disk (2000 (9.0.4402 SR-1))

    Is there a way of controlling the growth in size of Access databases?

    I use compact and repair quite often, but find this to be a slow and after the event process.

    Cheers,

    Niven <img src=/S/blackhole.gif border=0 alt=blackhole width=15 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access DataBase size on Disk (2000 (9.0.4402 SR-1))

    >> Is there a way of controlling the growth in size of Access databases?

    No, that's the way Access works. It frequently creates some free space to work with in the database, and never removes it. You can tick "Compact on Close" in the General tab of Tools | Options... Access will then perform a compact and repair when you close the database, or in a multi-user environment when the last user closes the database.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2003
    Location
    London, Gtr London, England
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access DataBase size on Disk (2000 (9.0.4402 SR-1))

    Many thanks your reply.

    I've used the compact on close as well, but I,ve had grief from users who suddenly decide they want to go back into the system again and can't.

    Does the unicode compression do anything in the text fields?

    Cheers,

    Niven

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access DataBase size on Disk (2000 (9.0.4402 SR-1))

    Unicode Compression is only relevant if you store characters in text fields that do not belong to the ANSI character set. All standard western characters, digits and punctuation are ANSI characters. Look up Unicode Compression in the online help for more info.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •