LinkBack URL
About LinkBacksHi All,
I have an access database that is approx. 660MB but I wanted to make it smaller so I tried to use compact and repair but it only reduced it to 599MB, does this seem right?
Thanks!
Rebelle
Hi All,
I have an access database that is approx. 660MB but I wanted to make it smaller so I tried to use compact and repair but it only reduced it to 599MB, does this seem right?
Thanks!
Rebelle
could be. the size depends on the table sizes, but also takes into account all transactions done to it. so yes, the size difference could seem right.
Quote of the Month:
INSIGHT: When the going gets tough, the tough get going. The smart left a long time ago.
Questions to Ponder:
Are people more violently opposed to fur rather than leather because it's much easier to harass rich women than motorcycle gangs?
iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm")
copyright © 2008 sbenj69
Sarchasm: The gulf between the author of sarcastic wit and the person who doesn't get it.
Hey Mehere
Ok, I had to import each file first into its own table then append to the real table so I can get rid of the imported one and see if that will help reduce the size too.
Thanks!
grr..ok, want to see what others like you do in this situation.
I used the Compact and Repair but now its down to 627MB, still to big to email and I can fit on CD to take over to user that will use it.
Each time I make a change to it I don't want to have to make a CD, what do you suggest I can do?
And FTP server comes to mind. There are several on which you can 'rent' space for a small fee -- I have been using FilesAnywhere: Free Drive, Online Storage, Dropbox, Backup, Send Files to move data from work to home. I have FTP'd several GB's this way.
I doubt you will ever be able to e-mail a database -- way too big.
However, what happens if you try to ZIP the file?
Wolffy
.-- ----- ..-. ..-. -.--
Opinions expressed are my own and do not necessity reflect those of any sane person. Any code provided is intended to be an example and is provided AS IS. Void where prohibited by law. Not valid in California. Your mileage may vary.
I don't know exactly your situation, but often, developers split databases..... since the backend holds all the data, it is usually the front end (interface/forms/reports/etc) that gets modified. BEFORE YOU EVER TRY ON A CUSTOMERS DATABASE, PRACTICE ON A TEST DATABASE! I would try with a simple database at first just to get the hang of it.
Join our Folding team: DeveloperBarn Folding
-----------------------------------
• Folding Stats - Stanford University
• Folding Stats - Extreme Over-Clocking
• Folding Stats - Kakao Stats
• Folding Stats - Xtreme CPU
-----------------------------------
Hey W0lffy
Hmm...ok, then maybe I should just put a on shared network drive. This is for the office, it just sometimes may be slow. I'll give this a try. Oh, when I tried to zip it only reduced by 1MB.
Hey Sbenj69
I've never used split but I'll see how to do it. I will be importing a new load of monthly data each month to the database.
Thanks peeps
Last edited by Rebelle; February 12th, 2010 at 08:32 AM.
Ok, weird....I re-zipped and it reduced it dramatically...from 709MB to 103MB...w00t! maybe something didn't quite work the first time.
Oh, if it's all internal, then just copy the database to a shared network drive and be done. Look into splitting the DB into Presentation/Data, as @sb suggests. I've copied large DVD iso files (3GB+) and it DOES take awhile, but is prolly faster than any other option.
Wolffy
.-- ----- ..-. ..-. -.--
Opinions expressed are my own and do not necessity reflect those of any sane person. Any code provided is intended to be an example and is provided AS IS. Void where prohibited by law. Not valid in California. Your mileage may vary.
Posting Permissions 
Reply With Quote
Bookmarks