How can in copy a mdb file which is around 6 mb to a floppy wihtout using any zip utility or without compressing it or splitting it
Printable View
How can in copy a mdb file which is around 6 mb to a floppy wihtout using any zip utility or without compressing it or splitting it
i hate to tell you this... but when your file says 6mb... and your disk cqapacity say 14. (Although u can get a program that will supposedly make it 2mb)...
6>2 therefore good luck :)>
-joe
?
There is Smart Drive floppy drive which can use both normal (1.44Mb) diskettes and High volume (120Mb) diskettes.
Hi
I assume you want to do that for making backups...
Just a wild guess...
open the database for binary (just the basic file open stuff), and read blocks of 1.4 mb (ok a little bit less is always smarter....) and save those blocks to the flop (or to another folder, whatever), and continue reading where you ended the last block, and do so until you reach EOF.
When setting the backup back (uh.... :-), start with the first file, and open the other files and append them to the 1st file (oh, make sure you have them in the right order..)
At least something like this is how my old boss did thr trick (ok, he did some checks too to make sure everything went ok, but I didn't see that code..)
Hope you get the idea...
Crazy D :-)
I thought he wanted to have it w/o splitting?
He says so in his question:"... w/o compressing or splitting"
AFAIK, 120MB disks are MOs (Magnato-Optic). Their drives are different & are not compatible with Floppys
Hi,
To my knowledge you can't... without compressing it.
So buy "WINZIP" and "WINZIP Selfextractor" and yr problem can be solved.
Look in www.winzip.com.
Good luck
Jan
True.. but it's pretty naive IMHO to think that 6mb can fit on 1.44Mb without splitting/ocmpressing :-)
Crazy D :-)
I could not resist responding to this one so I will give it a shot.
You have an .MDB file that is 6MB that needs to fit on a 1.44 Floppy....right?
First thing to do is go into MS Access and perform a function from the Tools menu called
Compact Database. I will assume that your file is bloated. It will create a new database that is usually a lot smaller. This cleans up all the garbage that has been deleted from the database and is no longer available.
If you have not done this, you need to. If you have and you are still at 6MB, then you need to split out your tables into seperate databases and link them in. If your tables database is 6mb and still needs to be on one floppy, then think about using a smaller subset of data.
I assume you are needed to sync a database that is on a notebook with one on a computer?
I think everyone thought you were asking a pretty lame question.
Wade Balzer
Hi
Nope, didn't think it was a lame question... although it looks like it... :-)
If it's indeed for replication, is this 6mb only the changes? if not, try to think of way to figure out which records have been changed and put these in a new database...
Although, I like Wade's idea of splitting the tables up in several db's :-)
Crazy D :-)
hi thanx for replying,
The thing is i wanna take backup thru an application and i cannot go to MS Access and do compression.Also i cannot ask my client to have access So if u have got any other idea please let me know at the earliest.Thanx.
If you are using VB and your program is backing up a .MDB file, and you simply want to copy a 6mb file to a 1.44 Floppy without reducing its size whatsoever, you are wasting everyones time here.
Lets start with the obvious. You will never fit anymore than 1.44mb on a 1.44 floppy. Even with compression, the compressed file would have to be 1.44mb...PERIOD. What about the MS 1.7mb formatted floppy?...That is NOT a 1.44 Floppy...is it? Neither is a 2.0 Floppy a 1.44 Floppy.
Now do some homework. If your application uses the Access Database, then you are also distributing the MS Access JET ENGINE, otherwise you could not touch the database. There is a function that you can call from VB to the Workspace that compacts the database from within VB. But your final result must be 1.44 mb or less PERIOD.
Being a programmer, you must use creativity and insight as to problems you encounter as well as the needed solutions. You have to give your customer a concrete solution to the challenges that you face, and if you need to make a backup of your data, then you somehow need to determine what data is volital and what is static and backup only the data that needs backing up. But if you are limiting yourself to backing up on a single 1.44 mb Floppy, then unless you follow my instructions, you will never accomplish your goal. When you choose to have your hands tied, eyes blindfolded, and one foot tied up to your neck, you won't go far. I certainly don't want to be in the passinger seat if your driving. If you want help being set free and eyes to see, I will help.
Wade Balzer
Hi,
Looking at the many reactions you got on this "impossible" question, you caused obviously headaches to some.
It seems that some sense of humour may avoid that.
Next time better
Ok, one other solution would be....
use a very tiny font and print it on very thin tissue paper. Place it in a bucket with several bricks on top of it and soak in water until all water is evaperated. Once the tissue paper is desolved, remove the bricks. Scrape out the letters and place on a scanner. Scan the letters using OCR software. Save results in ascii format. Should have no problem fitting on a floppy. ;-)
Wade Balzer
LOL
Crazy D :-)