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. :(
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?
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.
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.
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 ;)