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 :-)
If it contains no ole-fields, and no binary data
i.e all the field's data can be put in ascii form, then you can think of saving it as some ascii file
CSV format is directly compatible.
You can have your own INI-based format too.
I had compressed a 300+KB mdb to ~10k by INI-method (for bkup purpose) and you can write a small app that saves & restores.
But then, as the size grows, the saving may not be in the same percent-range!! For my case, the unwanted header of mdb could be more than data.
But this header would remain same, even as data grows.. so..
Right click on the 6mb file and select send and click on 3.5 Floppy (A).
If you are lucky you'll not get an error message
If you're not lucky you'll get an error message at this point you need to call microsoft helpdesk, and explain exactly what you are trying to do i.e. copy 6mb to 1.44mb.
I also suggest you call NASA, and tell them you're you're trying to create energy from no where and trying to disproove the law of conservation of energy.
hope this helps
Nurein
Superdisks are 120mb. They can also read/write normal 1.44mb floppys. Also, there is a Zip drive which is 250mb (~£60 UK for drive, £5 for disk).