Access Is Too Big! How To Reduce Size?

Hi, i am wondering how to reduce the size of access.
i have included pictures within forms which obviously made the database bigger (it is currently around 12mb).
However i have tried to delete the pictures to reduce the size, this method did not work at all. The database remains the same size.
does anyone have any suggestions on how to solve this problem i am having?



View Replies


How To Reduce The Size Of The MS Access


I have one problem.

If I create many many tables, then delete them, then create new tables, so on. The size of the MS Access file will become large.

So, how can I reduce the size of the file? Even though I delete the tables, the size will NOT become less, so how to reduce the size of the file?

Please let me know, thanks a lot. Thanks.

View Replies View Related

Reduce Screen Size - Version: 2002 (10.0) XP

On the Desktop in Microsoft Windows, it is possible to change the property settings to shrink the size of the screen so that more information can be shown on the screen. Is it possible to do the same thing through code in Access when entering an application and when leaving, it would return the screen back to the original size.

In other words, can code change the screen settings to 1024 x 768 and then return it to 800 x 680?

View Replies View Related

Reduce Size Of Database By Removing OLE Documents - Version: 2002 (10.0) XP

hello -

i recently learned how to remove photos from my database using the method described below. i'd like to further reduce the size of the database by removing OLE documents & pdf files...i thought i'd be able to tweak the method used for the photos & apply it to my docs, but i'm having no luck -any suggestions? for the record, i'd like for this function by opening the document in 'word', or the pdf in 'acrobat'...Thanks, Jody M

"Hello -

I recently was able to set up a form to include photos as described at (see below).

Option Compare Database

Private Sub Form_Current()

On Error Resume Next

Me![ImageFrame].Picture = Me![ImagePath]

End Sub

Private Sub ImagePath_AfterUpdate()

On Error Resume Next

Me![ImageFrame].Picture = Me![ImagePath]

End Sub

this was a big accomplishment for me, i'm not much at using ms visual basic...

i still have a relatively minor problem, though. not all of my clients have photos attached to their files. when i switch from a client that does have a photo to one that does not, the photo from the previous client shows up. i'd like to set it up so that if a client does not have a photo, something shows up to indicate 'no photo', or something like that...any easy way to do that? thanks iin advance for looking at this...Jody McClain

Re: Displaying a Photograph within a form Version: 2000 (9.0) [Re: JodyMac12]

Posted on 08/16/06 02:00 PM
Posted by freakazeud - Utter Access Editor
Posts: 17396 - Loc: MD, USA

Welcome to UA forums.
I think the best method to achieve that would be to create a default image which you display if no value is present. You can then alter your code to something like this:

If Len(Me!ImagePath & vbNullString) = 0 Then
Me![ImageFrame].Picture = "c:path to default imagedefault.bmp"
Me![ImageFrame].Picture = Me![ImagePath]
End If

Another option would be to clear out the image frame and display a hidden label e.g.:

If Len(Me!ImagePath & vbNullString) = 0 Then
Me![ImageFrame].Picture = ""
Me!YourLable.Visible = True
Me!YourLabel.Caption = "No Photo here"
Me![ImageFrame].Picture = Me![ImagePath]
Me!YourLable.Visible = False
End If

Good luck

View Replies View Related

Access Won't Allow Me To Reduce Height Of Detail Section - Version: 2002 (10.0) XP

I have 4 controls in the detail section, all in a row with a height of .1667 but Access won't let me reduce the height of the section to less than .6667. Even if I delete all 4 controls it won't let me reduce the height to less than .6667. It will let me expand the height and then reduce it back to .6667. This is true whether I drag the section boundary or change the height in properties.

Where is that magic number of .6667 coming from? How do I get past this?


View Replies View Related

Reduce Multiple Records To One


I hope you donít mind my using this forum as a learning tool. I am running an Access 2007 database. I am trying to create a query from 3 tables:
TblTrainingPrograms containing the following fields
Program Number (unique value)
Program Title
Program Date

TblInstructors with these fields
InstructorName, address, etc.

TblInstructorProgram with the fields
ProgramNumber(linking this instructor to a particular training)
InstructorNumber(in the case of multiple instructors for the same training, the user may add new records and enter ď1Ē, ď2Ē or ď3Ē here)

I need to run a query that will display even multiple instructor programs in one record, so that Instructor# 2 will appear in another field in the same record rather than having 2 or three records displayed in the datasheet view. Iíve tried several combinations, but when there is only one instructor, the Program does not appear in the query results.
I donít really know a lot about SQL, but Iím hoping there might be a way to do this that way. Any help would be appreciated.

Thanks in advance,


View Replies View Related

Reduce Decimal Places WITHOUT Rounding

Hey everyone! Hopefully, someone can help me with this. I've searched the forum and can't find anything on it.

I want to take a number and reduce the number of decimal places from 4 to 3 WITHOUT rounding it. Just chop off that 4th number...I don't care about it.


243.4586 = 243.458
22.0541 = 22.054
5.8577 = 5.857
1,587.2556 = 1,587.255

Seeing as how the numbers can be in the 10's, 100's, and 1000's, I can't just use the LEFT function. :D That, of course, would be too easy.

Suggestions? Solutions?

Thanks in advance!

View Replies View Related

How To Reduce Minute From Date Field

I want reduce one minute from my date field. My date field looks like this: 17.3.2006 3:57:00 and I want it to look like this:17.3.2006 3:55:00. I have tried to make it like this: DATEADD( minutes, -2, [StartTime]) AS NewStart. StartTime is date field. But this doesent work. Could somebody tell me how to reduce one minute from date field??

View Replies View Related

Reduce $ Amount Saved In Table On Entering Report - Version: 2000 (9.0)

First off, I am not sure I am posting in the right section, but I wasn't sure - if not I apologize!

Here is what I want to do. I have a payroll form that shows an itemized list of what the crew is getting paid for. It also has a field that shows if the crew owes the company any money (which is stored in the crew table, and the "pay list" is stored in the work order table). I then have an unbound box to input if the crew is paying back any money owed. If so, then the amount paid back should be automatically deducted from the amount owed and the the total payroll amount.

Two problems: I can input that amount paid back but I am processing multiple crew payrolls at the same time, so it doesn't know which crew to deduct from. Second, how do I save the changes in the table, so that when I print out the payroll report it is deducted from the correct crews total and shows on the report as a deduction. I know that you are not supposed to store calculated fields in a table, but I don't know how else to do this.

I had thought about if there was a way when you bring up the payroll report that a parameter field comes up for each crew that owes money and states something like: "Crew 1 owes $200 how much will be paid back from this payroll (text box for dollar amount). then what ever figure is entered it makes the deduction in the tables and shows it on the payroll for that crew. Then if another crew owes money, the same parameter field comes up again with that crew's name....)

Any body have any ideas? I am stumped on how to proceed with this!


View Replies View Related

Shrink Font Size To Fit Within Size Of Text Box? - Version: 2003 (11.0)

Is there any way to force data to fit inside a text box by automatically shrinking the font size to fit--like in Excel, you can shrink the text to fit inside the cell size, I want to do that with a control on an Access report.

View Replies View Related

Large Field Size = Larger Overall Database Size?

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...?

View Replies View Related

Access Size

I'm still in design phase but I'm going to have more than 30 tables. I know I'm going to have a pretty good number of forms, queries and reports. Should I start preparing for the worst in case this db gets too big? What kind of techiques can I use to make sure that it still runs quickly enough?



View Replies View Related

Size Of Access DB

Hi there..

we have one access database with size about 600mb and 1 million rows in one table.My concern is is it bad to have so much data in access database. If so what is the possible solution for that.


View Replies View Related

Access Size

I will like to know if access can store a lot of data. I am using a database that was written in access and the database has been in use since like 2004. How long can we still use this database. It is becoming slow and having one or two error messages.

View Replies View Related

Access Size

How big can an Access database be without having problems with it? How many records will it actually accept?


View Replies View Related

Monitoring Access DB Size

Hello all.

I have a large db. I need something to monitor the size of it. For example the db is saved on a server and used throughout the day. What I need is something to email me an alert when the db reaches 900mbs. Then I can compact and repair the database back down.

I do purge it annually though. Currently it is about 750 mbs.

Any thoughts, please let me know. Thanks much.

Using Access 97, 2000, and 2002.

View Replies View Related

Maximum Access Size

We have a database in Access 97 which is 0.8GB.

Can anyone tell me:
a) The maximum storage capacity.
b) What will happen when it reaches that size!

View Replies View Related

Does Access Have A Size Limit?


I am working on something and have to link I think a few thousand tables from a "store bought" database here at work. Is there a limit in regards to access? I know they are just linking but I didnt know if Access gets nutty after a while...

Anyone encounter functionality breakdown due to size or complexity?


View Replies View Related

Access Database Size Limits?

Hey guys,
Was wondering, what is the recommended maximum size for Access databases? I've heard that for very large databases that oracle is preferred. Would Access be appropriate for something on the scope of 5000 records of roughly 6 text and 2 number fields? Do people ever notice performance effects on databases of that size?

Also are there any ways to help reduce the size of the database? Do you recommend change the default field sizes where appropriate and would this have a noticeable effect on a database of this size? Any other suggestions to help keep the database manageable, and functioning?

I'm basically trying to figure out if there's much to worry about here, before I start importing my data. Thanks.

View Replies View Related

Optimize An Access Application Size

Hello everyone,

I've just finished my access application, but its size is 4 Mb. I expect that it will be much bigger once users begin to add records.

What is the best way in Access to keep the size of the file as small as possible?

Many thanks in advance,

View Replies View Related

Access System Size Recommendations

I have been given an Access database to maintain and it has some performance issues.
I have been looking through this forums for recommendatons regardng size etc but didn't really find anything.

It is all in one file (might consider splitting it..) and it has about 350 forms, 300 database queries, 130 database tables and 200 Macros!! Filesize something around 200 MB.

In one of the forms there is a drop down that when changed refreshes two other dropdowns. I have chyecked the queris used and they are really fast but it still takes at least 6-7 seconds for the 2 dropdowns to reload!
I don't know if it is due to the way it is done, the VB code calls a macro that calls a query.
Personally I wouldn't have done it like that but there has been about 2 years since I did anything complicated with access..

Or is it the size/complexity of it that makes it slow? Does anyone have experince of a similar system?

Thanks /H

View Replies View Related

Increased Size Of Access Front End

I have been posting a lot recently and have greatly appreciated the help. I have just been looking at the size of a ms access project, this is a front end for another database so contains no data (runs as an mde for most). I have made a few modifications using access 2007 including at one point having it in the new file format, this was to fix a bug I was getting that caused a particular crash. I found converting it to 2007 and back cleared the problem.

Anyway the main things I added were an active directory query to enable certain buttons for a limited number of users. Including the VBA reference to do this. I also added a new report that when run in access 2007 (even in 2003 format) allows the new reportview so I can have an onclick event within the report for the user to gather more information which it wouldn't be appropriate to have on the main report.

This has balooned the size from 5mb to 50mb even after a compact and repair. Any suggestions as to possible causes could it really be adding vba references causing that much of an increase. I should say i'm not particularly worried it's ok for it to be that size I just wonder why such a massive difference.

View Replies View Related

Access Database Size Issue

I just got done migrating the tables in my database to a SQL server, I went in and deleted the extra table that was created with the migration manager so all the data in my database is on a SQL Server, For some reason the size of the database is still the same. Why is that?

I even when in and deleted the tables query and forms but the size is still the same, if there some setting that im missing?


View Replies View Related

Anyone Have A Guess As Access 12 Size Limitations?

I've got a database that is about to blowup with Access' 2GB limit. Just wondering if I should wait for Access 12.

View Replies View Related

Access Calender Size Problem

Im Making a Room Booking System for Our Meeting room,

there is only one room, so its easy to use the Calender(MSCAL.Calendar.7)value to pull a query for whats happening on anyone day, this also allows to add new entries,

my problem is Ive writting it in MSA2003,

and my main user is in 2000, when she opens the form with the calender on it the fonts are all reset to 1.5 in size,

and this is not useable,

has anyone seen this before or had something similar,
I thought Id just use VBA to reset the font sizes in the Form_open routine, but I cannot get VB to Access those properties of the calender,

so Im a little Stumped.

View Replies View Related

Access Database File Size

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?

View Replies View Related

Decrease The Size Of MC Access 97 - Version: 97 (8.0)

My db was 346mb, I ran a decomplie, repair and compact and it reduced the size to 183mb, I also went thru and deleted all items not needed. I need to reduce it more so that my VPN remote location can still open it. Right now it just take forever to open or do anything across the VPN, our conecction is a fractional T1 with 868k on my end and 1.1m on the remote end.
Does anyone have any suggestions on how to speed up my remote location in access?

I tried to split the database and get nothing but errors. The database was poorly designed and I am not able to go thru every table, form etc to try and fix.

View Replies View Related

Open MS Access Window In A Certain Position And Size


I would like to open the MS Access Window in a certain position and size.

Somehow similar to open a form when using:
- to set the position and size:

Private Sub Form_Load()
Form.Move Left:=11500, Top:=6500, Width:=7000, Height:=6000
End Sub

I would like to open the MS Access Window within the screen area at a certain location, and having a certain size.
Is there any option in the Access Menu, or I can write some code, and where has to be written, so when I double click on the *.mdb file, the MS Access Window will open where I want and the size I want.

Thank you.

View Replies View Related

Size Limit For Access - Version: 2003 (11.0)

I read that MS Access has a 2 GiG size limit, but I have a database that is 2.7 GIG's, is this something to do with loaded pics', etc...

View Replies View Related

Access Application Window Size And Position

Hi all,

not sure if this is the right forum but seemed as good as any...

One of my teams use an in-house system in conjunction with an Access database that we've developed. Part of their process involves reading information from this system and keying it onto the database. What I'd like to be able to do is write some code that will resize the access application window to a particular area and move it to some part of the screen. This will enable both windows to be visible and should improve productivity.

Is it possible? I'm feeling that it will involve some API calls which is not my area of expertise. Any pointers in the right direction would be great....

Thanks in advance...

View Replies View Related

Access DB File Size - Version: 2000 (9.0)

I have an access db application which has got 8 forms and 6 modules.

Everytime i make a small change, the size of the file is increasing like anything. When i started with it, it was about 10 MB or something, but now it has become 35MB. I have not added much of the code also to my application. I am worried about it's size a lot. This is very critical and need assistance urgently.

Please help me with a solution.

Thanks in advance,

View Replies View Related

Size Of Access Database Grows After Preview Of Report


I really need help with this. I have a database that is quite large and is accessed through VPN. When I shrink and compact the database it goes to a respectable size. But over time everytime a report is previewed the size of the database grows. Or every access it grows to double its size in no time at all.

Any ideas... on what would make it grow and how to stop it.

Thanks it is appreciated.

View Replies View Related

File Size Of Access Databse Decreases? Random

I have been using access 2003 at my work place.

When I bring back my access 2003 project from work back home, i open the project at home, I am using access 2002 or 2000 format.

Then I notice if I save a copy of my work using access 2002, while initially using an access 2003 database, the file size decresaseas dramatically, from like 3mb to 800 kb?

any reason why?

No data seems 2 be lost.


View Replies View Related

Copyrights 2005-15, All rights reserved