SitePoint Sponsor |
|
User Tag List
Results 1 to 5 of 5
Thread: Access...
-
Oct 31, 2001, 05:06 #1
- 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
-
Oct 31, 2001, 14:07 #2
- 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!?!?
-
Nov 2, 2001, 18:51 #3
- 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.
-
Nov 5, 2001, 11:47 #4
- 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.
-
Nov 5, 2001, 14:27 #5
- 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