Access Is Too Big! How To Reduce Size?

Dec 7, 2005

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

Oct 4, 2005


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 2 Replies View Related

Modules & VBA :: How To Reduce Size Of MDB

Sep 26, 2013

My A2003 FE mdb has grown over the years and is now about 180Mb.

Is it advisable to copy the contents of the FE mdb into a blank A2003, every few months, in an attempt to make it smaller?

Is there something to watch out for during the copy?

View 7 Replies View Related

General :: How To Reduce Size Of PDF

May 18, 2013

I used to generate PDFs in A2003 with Leban's code, and they came out at about 10K.

in A2010 these same PDFs are coming out at about 250K - whether i use docmd.outputto, or still use the previous code

is there any way to reduce the size of the pdfs?

View 6 Replies View Related

Reduce Multiple Records To One

Jun 28, 2007


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 2 Replies View Related

Reduce Decimal Places WITHOUT Rounding

Feb 15, 2006

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 8 Replies View Related

How To Reduce Minute From Date Field

Aug 1, 2006

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 2 Replies View Related

Queries :: How To Reduce Number Of Item With Update

Nov 20, 2014

How do you update a table by reducing a number by 10?

My assignment question is:

10 students have left GY101. Write an SQL UPDATE statement to reduce the class size by 10 for all modules taken by GY101 students.

I can display the students who take GY101 with the following code

SELECT moduleCode, classSize
WHERE moduleCode IN (SELECT modCode
WHERE courseCode = "GY101"));

But how to reduce the number by 10.

View 1 Replies View Related

Large Field Size = Larger Overall Database Size?

Aug 29, 2005

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 3 Replies View Related

Tables :: Queue With Several Concurrent Entries - Reduce Duplicate Orders

Jan 24, 2013

I'm trying to create a database that is going to be used to deliver some work to several of our users. Each time they open a specific form they'll be delivered a job.

The tables are organized somewhat like this



Now it works like this, the user gets an ID_JOB from queue

In the form they get all the all the work orders with that ID_JOB, the thing is i'm getting users with same duplicate orders cause i can't update the locked efficiently.

Regarding the users, the database is split, multi-user, with >30 simultaneously

I'm been trying to use dao.recordset, with transactions to try and reduce the duplicate orders.

View 8 Replies View Related

Queries :: How To Reduce Down Data Set To Get A List Of All Unique Combinations Of Column

Jul 8, 2014

I am new to Access and am trying to reduce a dataset I am working with to make it managable for Excel. I have three columns which have three unique parameters and one column with numberical content.

Column A Column B Column C Column D
NJ Red Monday 10
NJ Red Tuesday 20
NJ Yellow Wednesday 30
NY Red Monday 35
NY Green Tuesday 40
NY Green Wednesday 60

I want to elimiate column C from the dataset, and sum column D for every unique combination of Column A & Column B. I have figured out how to reduce down the dataset to get a list of all unique combinations of Column A&B,what formula I can use in a query to sum column D on my table for every unique combination of column A&B. This is a simple SUMIF in excel, but my dataset is too large for excel.

View 4 Replies View Related

Access Size

May 20, 2005

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 4 Replies View Related

Size Of Access DB

Mar 26, 2007

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 3 Replies View Related

Access Size

Dec 20, 2007

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 2 Replies View Related

Access Size

Aug 20, 2004

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


View 6 Replies View Related

Forms :: User View - Reduce Amount Of Options On Menu Bars

Aug 15, 2013

I have created a front end and put into production for my users but I want to reduce the amount of menu bar options they see so someone cant click on a button wondering what it does and mess something up. What is the best way to reduce the amount of options a user sees on the menu bars when they open the front end of the db?

View 1 Replies View Related

Monitoring Access DB Size

Apr 6, 2006

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 2 Replies View Related

Maximum Access Size

Oct 3, 2006

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 3 Replies View Related

Does Access Have A Size Limit?

Apr 3, 2007


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 3 Replies View Related

Access Database Size Limits?

Sep 30, 2005

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 3 Replies View Related

Optimize An Access Application Size

Jan 1, 2008

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 8 Replies View Related

Access System Size Recommendations

Jan 3, 2008

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 3 Replies View Related

Increased Size Of Access Front End

Jan 25, 2008

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 2 Replies View Related

Access Database Size Issue

Apr 5, 2008

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 3 Replies View Related

Anyone Have A Guess As Access 12 Size Limitations?

Apr 21, 2006

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

View 2 Replies View Related

Access Calender Size Problem

Dec 12, 2006

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 2 Replies View Related

Copyrights 2005-15, All rights reserved