o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Access Database Compression -

We have a real time process and i have to log all the data periodically into an Access database using VB6 as front end for reporting purposes.

The problem is that the size of the database increases drastically so i purge the data after 30 days (Delete the records older than 30 days).

But i observed that the database size does not reduce even after purging the records.

What do i need to reduce the size of the database ?

Datamanager allows me to compress the database to a new file. How Can i comperss the database from VB ?

I also need to send the database file after zipping & compressing it to the floppy drive how can i do it from VB6 ?

Jaspal Muker

 

compression algorithm -
hello, i am looking for an compression algorithm which offers the most compression. there are loads of different ones but i dont know which one has the most compression. which compression algorithm offers the most compression and is also lossless? i have tried zlib.dll but for some re

"Invalid field data type." when converting to prior version of MS Access. -
I'm developing a website that uses a MS Access database. I'm creating the database in Access 2000, but the web server can only open Access 97 databases. I've been using the "Convert Database -> To prior Access Version" for the web server to use, and it's been working fine.

More Compression -
Hi all, It's not really a problem, but more of a disappointment. I tried both the DAO and Jet Replication Compress Database methods on an Access database that used to have forms, reports and macros. I deleted all of those and just have data. When I run the compact and repair ut

Change Unicode Compression in Code -
I'm using Access 2000 and I need to process a large number of tables. I already know how to access a table and most of the field properties. But I don't know how to get and set the "Unicode Compression" property for a field. I need to change the "Unicode Compression&q

Limiting CPU usage or in background -
Hello, Assume I have a form with a few buttons. Each button invokes something (no matter what) Is it possible to limit the resources for a process? eg. I work with an access database. From VB I can compact the database. Since the database is +- 200 MB large this can take a wh

Unicode Compression -
Hi: I want to put the "Unicode Compression" in access database in "true" but I had found nothing about the instrution to do this: this is the code for "allowzerolenght": fld.AllowZeroLength = True and for unicode compression? Thanks

Unicode Compression in Jet 4.0 -
I can't for the life of me figure out how to set the Unicode Compression option in code for fields in my tables. I'm using DAO 3.6 to modify the fields and I can't find the function. For a DAO database, I'm doing as follows... DAODatabase.DAOtblDef.Fields(Index). I would

Compression... -
Hiyas, I need to compress some text-based data files I'm using with a program I'm making. I need a really good compression rate (lower than 10% of the original file size). Does anyone have free-to-use code or an algorithm? My program will probably be commercial, so I don't think

LZMA Compression Module -
Does anyone know where I could find an LZMA compression module? I've heard that it has very good compression and is fast. I've looked all over but I haven't even found one webpage about LZMA compression in VB.

Looking for da famous compression software -
I remember a long time ago I used to see a certain compression format around... I uncompressed a 120MB file to 2GB... I cant recall what it was called (UHARC maybe?) I'm looking for something like that...What's the best compression program that I can find? the one that I'm talkign a

Data-Compression Algorithms -
Hi all, I wanted to ask you if you know some forums or known websites for lossless data-compression algorithms. Second, I wanted to ask you: If I invent a new compression technique which can compress even ZIP and MP3 files dramatically, could I make out of this useful algorithm any

[2005] PDF Compression -
I'm working with a program that loads PDFs out of a database. Sometimes, I expect the customers to want to use this program remotely. I was toying with some code to compress the PDF files to make the transfer time shorter (a 60 MB file over a T1 VPN ain't quick), but I kept coming up w

Access Database Compression Stops ASP Working -
Why does my ASP website stop working when I use the database compress tool in access? Is there any way around this because I would like (but not have to) make the database files smaller

[2.0] Database Compression -
Hi guys. I have a situation that I'm currently trying to figure out ideas about. We have a database here at my work which is not a popular database. The name of the database is 'progress'. Now what is currently done is that for a backup, a batch file runs every night that makes a ZIP f

Built in .ZIP compression -
Does VB 6 have built in .zip compression? Windows XP has .zip compression built in so I was just wondering. Any open source/free libraries out there? Thanks.

Access Database Compression -
We have a real time process and i have to log all the data periodically into an Access database using VB6 as front end for reporting purposes. The problem is that the size of the database increases drastically so i purge the data after 30 days (Delete the records older than 30 days).

[2008] Zlib Compression -
Hey. I was looking around on google for a .Net zlib compression library, although I had no success in finding one that actually worked. So now I'm asking here; does anyone know of, or have, a working VB.Net zlib compression library? I really need one for a program of mine!

NT Compression -
just wondering if ne1 here knows how to do NT Compression and could post an example thanks in advance Kris Bennett

Audio Compression Manager -
I found a terrific sample on the MSDN cd for converting wave files via ACM (Audio Compression Manager). For example converting from PCM to IMA ADPCM and vice versa. Unfortunately this was for Visual C++, and although it works exactly how I want it to, I need to use it in vb. How d

HELP!!! MP3 WAV IMA ADPCM Audio Compression -
Guys, I know it's probably impossible but I would to play a compressed audio file directly to an audio device (perhaps the second sound card). But to do so would require you setting up a stream converter with the Audio Compression Manager. I know this is entirely possible in VC+

compression through code/api -
Hi, I was wondering if it's possible to compress/decompress files without using dll's or controls? It seems that all the code out there for compression through VB utiltizes dll's or controls. Is there a reason for this? Is it not possible to do compression through code or api u

Compression -
Hi, does anyone know how I can add compression to my program without using a control. I need source code.

Best compression algorithm / program -
Is there anything better than winrar's compression method?

[2.0] C# Compression -
I am very curios about compression. Is it possible to get the source of the GZIP class?

[02/03] Accessing WinXP file compression functionality from code -
Does anyone know if there is anyway to access and make use of the inbuilt WinXP file compression functionality from VB.Net. I have looked at various components for doing this but wondered if it was possible to do it using WinXP. Thanks

Compression algorithms in VB -
Are there anyone here who knows anything about data compression in pure VB?

Compression for JPG -
Could someone post the Code for the compression of a JPG Thanks, Justin

CD-Compression -
does anyone know where i can get a CD compression program, as i've seen a 700 meg CD compressed to 840 somethin, anyway he wouldn't tell me what to use, Anyone pls?

RLE Compression -
Can I use RLE Compression for free? Without getting sewed?

libpng compression compared with Irfanview -
I am using libpng to compress png files and am very dissapointed at the terrible compression ratio compared to Irfanview. 5.7megs-libpng and 968kb-Irfanview I did everything I could to get the best compression: png_set_compression_level(png_ptr, Z_BEST_COMPRESSION); png_set_fi

little about compression -
how can i compres a certain access database in vb? is it possible ?

Fast LZSS Compression Function -
Can someone please somehow make this compression function faster? This is the best compression method that I have seen so far for my project. The only thing is it takes forever to compress even 1mb. I also need a progress bar. http://pscode.com/vb/scripts/ShowCod...=1821&lngWId=1

Progress Bar and Database Compression -
Hello, I was hoping someone could help me out. I make a simple compression utility that will compress a database using this command: JRO.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & srcDB & ";Jet OLEDBatabase Password=" & &q

Video Compression format -
guys, do you know how to add more pixel depth or compression format ?? currently my system only got YUY2 i hope to get rgb24 or i420

ZIP Compression Using Pure Visual Basic -
Does anyone have any kind of module, class module, etc. that can compress files using ZIP compression?

Encryption and Compression -
I need an encryption routine with the emphasis being on speed, and the same for compression. I'd like them to be Visual Basic source if that's possible.

Compression anyone -
Im working with compression, and I want to open all files as binary files, as in, right down to the bare bones of the file. How can I do this ?

Example of Compression dll.... -
Anyone know where I can find an example of a compression dll in vb code have searched through many sites an had know luck

(For compression programmers only). New breakthrough in compression tech! -
Most or some of you've heard this news. ZeoSync corp has developed a compression algorithm which can beat any existing compression tech in terms of ratio of reduction. Normally, for a randomly generated data, it goes not further than 1 to 10. This is the case of current tech, wher

SQL and ADO problem... -
I know how to add a field to a table in an Access 2000 Database. I use this: ALTER TABLE tablename ADD fieldname Char(50) But how do I allow the field to use Unicode Compression?