File Size Recalculated After Images Deleted From Database?
Aug 23, 2004
hi, everyone.
here is the situation - i have a database in which i originally imbedded a bunch of bmp images. then i figured out another way of presenting my data, and i deleted all those fields with images from my database. the database file size with the images was about 90MB, but after i deleted the images it was still 90MB. why??? at this point the database contains to tables, one 2 by 2 with some text, and the other is 20 by 3 with some text, and the file size is 90MB. i totally dont understand this. can anybody explain to me what's going on?
thanx!
I had a massive Access file of almost a GB in size. and I deleted all records off the tables hoping it would shrink and my purpose was to have the tables alone in their structures. However despite deleting all records, the database file size seems to stay the same. anybody knows why this is so? I don't think we can "commit" changes to databases done in access as it is done in other databases. anybody knows why this is so?
I have some databases that I am importing data into but the records are so large (over 4 to 6 million) that they are making the file reached the 2 gig maximum.
Questions:
1) I have the imput tables broken down in to thirds of a month (i.e. Day 1 to Day 10, Day 11 to Day 20, Day 21 to Day 31) so what I was thinking is that there might be a way to just like three different databases together or four and have one be the master puller of the other three?
2) Currently, I have reports and queries that pull from one large table. So how would I set up the query reports etc. to pull from all three databases into one reports or query. Or is this not possible.
If you think of a better way to arrange or work around this problem then I am surely open to suggestions.
I'm having a problem with my database filesize getting larger with the more searches i do. At first i couldn't figure out how it was getting so big, but then i tried a few things and came to the conclusion that every time i do a search it increases its filezile.what made me notice this at first is that the file size of the original copy of my db is 13MB, but if i Save As a different name, like Assets_Backup, then the size of the new file is only 2MB, and after i do some searches it increases again.here is a file with just my search form and search query so you can see the code for them. i removed everything else to shrink the file down, which also made the search form not function properly, but i thought the design and code might be enough.is there something that i can change to keep it from remembering every search?thanks for any help.--------------------after searching the topic a bit more i've found that compacting the database will shrink it down to 2MB, but is this something that will have to be done on a regular basis, or is there a way for it to do it on its own?
Will keeping your field size shorter result in a smaller MDB file?
Or does Access only use as much space as there is real data in its fields.
Way back in the dBASE III days, dBASE would pad all your "real" information with as many spaces as necessary to fill up your field. I suspect that the MDB structure is probably smarter than that.
Another question on the same topic - I believe there is a maximum number of characters in a record (4000?). Can your field sizes add up to more than 4000, as long as the actual data, all combined, never totals 4000...? Thanks............ ..dc
Hello people of access world forums. I've decided to design a simple access db with 2003 version but with 2000 compatibility and everything appear to work ok.
After designing and testing the db, I have set the Jet user-level security options as described in some documentation and set the startup options too for a "clean type" start. Everything is ok: I have created the workgroup in a new .mdw file, joined the workgroup, set the users, set the groups, protect the forms I wanted to. If I try to open the db, it asks for user and password and the db works as espected about security.
But if I delete, move or change the .mdw filename, the db turns accesible without the implemented security. Only the startup option works but no user is prompted and the protected items turns unprotected.
I would like to know how can I associate the .mdw to the .mdb so I can't access the .mdb if the .mdw file is not present (i.e. copying the .mdb to another computer or something).
I am trying to display images in my form. The problem I have is that these image files are from an external source and don't have the traditional image file extensions such as .jpg, .bmp, etc. Each one of the image files end with the sequence number of the image subject, ie: .0011 or .0021, etc. I can change the file extension to one of the traditional file extension, and it would open. However, there are several thousand images. How could I get access to recognize the generic file extensions?
on a form i have 2 fields one for import a file with the filedialog 2e for the size of that file how can i have te size from the file in that field can someone help me with that code
Hi, I was recently searching on the site for information leading to the compiling of an .exe file from the Access database. What I come to realize is that this is not possible. I was led to the MS Visual Studio 2005 for MS office studio and the MS Office Access 2003 Developer Extensions for it to use the Access runtime (As I came to understand) without having to install Access. If I am at all wrong up to this point please let me know. I was just wondering about that for clarification, my real concern is regarding the size of my database and the problem making it into an MDE.
As of now, my program is at roughly 30 mb, which I did not think was too incredibly large. However, Access will not allow me to create the MDE file. Where I think my problem is lying is that I have images scanned into the DB and then text boxes on top allowing me to essentially type a form and print it out.
Is there a better, more size efficient way of doing this? I have a hunch that it is the images that are not allowing for the MDE export, but I did not think they were all too large in size. If anyone has any comments that may help I would be very appreciative. Thanks in advance.
I have developed a Access program which import excel tables into the the database and queries some data and writes it into an excel file...
The problem I am having is that after the program is loaded... the file size of my mdb file increase by more than 3 mb..
I tried deleting all the objects in the file.. and the size doesnt reduce at all, When I import tables, I delete the previous one.. so I don't think it would be that...
The only thing I think the problem mite be is the life line of the variables..
Is it that after I run the program... the Variables stays there and ocupies space...??
afaik, the variables "dies" after the program is finished loading.... if not, is there a way to "kill" the variable at the end of the program? so far, at the end of the program, I have set my objects = nothing.. to release them... but doesnt seem to help at all
Hi, i am new to access. Anyone know why my .mdb file size Growing. Even when i delete the data from table and done with the compact and repair. i am doing my first small project with one table and 10 querys and 5 repots. each time i edit the query or report the file the size goes on increasing. i have not more then 100 records in my database. i only edit my records when ever i edit my records .mdb file size grows so any one could help me to make it constant. plz help
Yesterday my DB was 5MB. Today its 50MB. I haven't embeded any images etc... I can't see any reason why the DB would expand like this. The only thing I can think of is that perhaps there is a variable somewhere that allocates memory. What should I be looking for??
I'm trying to set up a simple query that links four tables. However, the tables are extremely large, all in excess of 1.5GB each so I had to split the tables up into four separate DBs. I've tried the following with no success:
1) Link the 4 tables in the DB which contains my primary key. This quickly inflates increases the file size above 2GB and won't let me go any further.
2) Build a remote query to connect the four tables. This looked promising until I tried to run the query and it became evident that it only knows to point to the last database source that you specified.
I'm running everything locally on my C drive. The data source are simple text files (1.6 million rows) from the FDA website.
I have created a db and am having serious problems, the size of the complete db is 3mb, and when split its 500k, the trouble I am having is that when putting the db on the network server and you try and open it based from home it takes so long for both the full db and the split.
The main db has one page that all staff need to see and have a quick response when opening on VPN client. The form I want to open has a combo box that lets the employee select the company and all the information updates on the form.
I tried making a page in acces to do the same thing but having problems
Is this possible what I am trying to do or is there an easy faster option.
How would you tie tiff images to an access database. for example. if I have a tiff image of an invoice, i would want the customer to be able to search for an invoice using information about the image, like invoice #, cutomer #, purchase price, etc.
I can not make the link thing work, and now I cannot even make it work with the images being stored in the database. My DB is very simple, and I am attaching it, along with my Images folder and a couple images. If ANYONE can figure out my problem and suggest how to fix it I would greatly appreciate it!
First let me apologize if I am being stupid, quite new to Access. I am trying to create a database with some pictures in it; I want to design a form that changes the image with each record, (Its for work they want a database of our employees info with a photo of each employee) reading though the help file it seams I need to add a bound image control, I have tried 2 different ways and am still getting the same problem, the first way I tried was to create a text field with the address off the photos (there are .jpg’s) and then add a bound image control on the form and link it to the field. Problem is this just displays the name of the file not the picture (e.g. as you go though the records it shows Mark.jpg, Simon,jpg, Louise.jpg….) I then tried to add a OLE field and add the files that way, if I click on add from file when creating the object I get the same problem just displays the file name, If I click create new bitmap image it works and displays the picture, the problem is the data base file then becomes huge (it was 45 meg with 2 photos, I need to add about 150 in total!. Am I being totaly dumb, is there a way of getting Access to display Jpg’s and ideally have them linked to instead of embedded to keep the size of the database down.
Sorry for rambling! (oh yeh and I am using Access 2003)
I have been asked to develop a new application (not using Access).I have the original Access Database and while I can get the data out I was wondering how I can get the images out of the database.
I produce visualisations for architecture companies and use a lot of 2d images of people, cars, trees, skies, etc. As it stands now, I have a folder that contains a huge amount of images that I flip through when I create a new image. I have seen that some websites, such as [URL] .... allow you to filter through an image database based on different tags.
I would like to create a similar database, but stored locally on my computer. I have actually never used Microsoft Access before, but I'm thinking that this might be the best program for me to use. Is this true?
Essentially I would like to organize my library of images of 2D people based on things like: 'staring', 'bicycle', 'looking up', 'back view', 'crowds', 'pointing', 'sitting' etc.
I am creating a database for vehicles in my town. I need to document multiple images per car. How can I do this? Ive tried Image and Bound Object frame in Design view but it seems that I can only add one picture per record...
I am working on a computer task for school and i want to add a field to a database that displays pictures of different kinds of fish. I've been searching for a solution on the internet the whole morning, but i cant seem to get it right. Some sights recommend inserting an OLE object, while others say i should insert the paths in a textfield. The second option sounded the best, but how do i insert the path and how do i get the database to display the pictures? I know the images should be saved in the same file in the database. Can I only insert bitmap images or is it possible to use jpeg?
I accidentally (really don't know how I did it) deleted the dollar signs from the entire database that I use daily. I did not set this database up, and don't really know how to much more than enter the data, and do basic stuff. How can I put the dollar signs back on all the forms/queries/reports that I use daily?
I have a strange issue. First off I have a front end in Access 2000 as a MDE file linked to a mdb data file.
Issue number 1: The MDE file almost doubles in size daily. Yes, the mde file not mdb (it grows slowly and expectedly as data is added and deleted) . I expected the MDE file to stay a static size. Is this normal, what causes this?
Issue number 2: I had on 3 occasions a query in the mde file suddenly pop up with a ”cannot repeat table name ‘Nameoftable’ in FROM clause”. I go into the mde file, SQL query view and delete the extra table name and all is fine for awhile. After the second time I did away with that quey and rewrote the query for my form a different way. It’s come back once again now for anther table. Has anyone heard of Access doing this?
I also note that the modified date of the file keeps changing. I am wondering if someone is tampering. My client that has this software is very naďve.
The MS site has no information regarding either behaviour.