SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Thread: Access...

  1. #1
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Access...

    I don't really have much experince with Access as a program. All I do is open it, build database, then close it.

    What I was wondering if the compress option, I know this question is prolly going to be completly stupid, would slow down access to the database? Or if you can even access the database when its compressed.

    I know I could just go and try it, but i really don't have time.

    Thanks


  2. #2
    Digital Warrior Renegade's Avatar
    Join Date
    Nov 2000
    Location
    Portland, OR
    Posts
    480
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Compression always slows down processing. As the computer has to run the compression algorithim. It usually a question of how much...

    Are you talking about built in access compression? Or at the filesystem level like the NTFS compression?
    --There's my 1.5 cents, now where is my change!?!?

  3. #3
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm talking about in-built access compression.

    I generally avoid using compression, but I have a databse from a client that is 27meg uncompressed, and when its compressed, its 14meg.


  4. #4
    SitePoint Evangelist Umair.ms's Avatar
    Join Date
    Sep 2000
    Location
    Lahore, Pakistan
    Posts
    567
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    are you talking about compressing the database or compacting the database??? Because compacting the database, makes it more effecient. When any data is deleted in access, the file becomes fragmented. "Compact" option does something to an Access file - what the "Defragmenter" utility does with a hard disk.
    TinyPlanet.org
    Discuss and Debate World Events, Politics and Religion.
    Interact and Share your Views with People around the Globe.

  5. #5
    SitePoint Wizard big_al's Avatar
    Join Date
    May 2000
    Location
    Victoria, Australia
    Posts
    1,661
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Umair is right,

    The "Compact and Repair" feature is very good, it will redice the size of your database a fair bit if it has not been done in a fair while
    .NET Code Monkey


Bookmarks

Posting Permissions

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