Should Data Be Encoded For Db Size Reduction?

Dec 5, 2005

I have been creating a personal database (access 2002) to keep help keep track of all the stupid things I own. I was wondering what people think about encoding data to help reduce database size. I know that for my small database it probably doesnt matter, but it it worth it to enocde colors into a couple of characters (2) instead of having a text entry that could fit a color spelled out (15). Ex.

Gray vs. G
Dark Gray vs. DG
Black vs. B
Blue vs. BL
etc.

I have come across a number of times when I can encode data and then write code for my forms to interperet that data back to plain english for me. Am I just wasting time if I do this? Or is there a point where this is recommended? Thanks for your advice.

View Replies


ADVERTISEMENT

Reduction Of A Database Size - Implications + Advice

Jul 14, 2006

Hi there

I want to know if anyone has taken a large database (e.g 400,000 records) and had to take a subsection of this so to reduce size. (E.g you randomly would like to take 20,000 records). I need to reduce a database size for a test situation but would like to know what I should consider when reducing the size in this way.

Do I take the base database structure – table organisation with fields linkages etc and load data in?

I have some help in this task but would like to know of any advice that could be provided.

Many thanks

View 1 Replies View Related

Stock Reduction

Apr 30, 2007

Hi
Can anyone help.

I have a table with units in stock eg. beans 27 tins. An order is placed for 6 tins of beans. How can I reduce the amount of stock in my stock table.

Hope someone can help.

Thanks:confused:

View 4 Replies View Related

Automatic Stock Reduction

Nov 27, 2007

Is there anyway to automatically reduce the quantity of stock. I have set up a table, with a field for the quantity of items in stock. I want to be able to automatically reduce this value at the click of a button, a possible macro???

Q. How is this done?
A. A sales person selects his name from a combo box, then he selects the customers name. Following this he then enters the book(s) ordered by this customer, then the quantity of each needed, and finally the discount. Ideally what I would like is for when the sales person enters the quantity of each book, for the amount in stock (Tbl_books) to be reduced by the amount entered in the qunatity field on the order form. If there are not enough copies of the book available for the order to be completed, then a small message box appears telling the sales person that their are not enough copies left in stock (a possible validation rule). Now this is where it gets tricky. If the sales person enters a incorect value for the quantity of books ordered, i.e. 2 instead of 1, then when he corrects the value, the number of books in stock (Tbl_Books) is to increase by 1.

I have absolutly no idea as to how to approach this, I have attached a printscreen from the relationships page, as well as a printscreen from the order form. Would you like a printscreen from any other table or form?

Relationships:
http://img28.picoodle.com/img/img28/5/11/27/f_Untitled2m_602830c.jpg
Stock Form:
http://img28.picoodle.com/img/img28/5/11/27/f_Untitled1m_0ecc314.jpg

Thanking you in advanced
CJM

View 5 Replies View Related

Queries :: Cumulative Reduction Of Stock

Aug 20, 2013

queries cumulative reduction, basically i have 2 tables, with the follow data

stock table
idProduct
QuantityStock

[Code]....

View 4 Replies View Related

Calculating Data Size Limits

Dec 27, 2006

I am trying to project how long it will take to reach the 2GB Access limit in a specific project.

My client downloads approx 250,000 records on a monthly basis. I've been provided w/ a sample Excel spreadsheet. I filled a spreadsheet w/ the max number of rows (65536 rows w/ 10 columns of data), and imported that into a new table in a new .mdb file. I copied the table 4 times, so I now have 4 tables of 65536 records each. Compacted before closing. Size was about 52MB. Assuming consistency, I calculate that the size limit would be reached in about 36 months.

262,000 records = 52 MB. 52 MB a month x 36 months = 1,872,000 MB.

Does my projection appear sound?

Thanks!

View 2 Replies View Related

Limit Size Of Data RETURNED

Feb 9, 2006

One of my tables contains data/records like this: 02092006P1235665

Does anyone know how I would write a query to return only the first 8 characters from these records, not the entire field.

For simplicity lets call the table RECEIPTS and the field RECEIPT_NUMBER

View 3 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...?
Thanks............
..dc

View 3 Replies View Related

Common Data In Two Tables Of Different Size, How Do I Append From One To The Other..?

Jul 23, 2006

Hello,

Firstly I would like to state that i have very little knowledge of Access databases (my job is not computer related) but I am trying my best to get a few issues sorted...
So here it goes: I have 2 tables, one large table with about 3-4000 rows(horizontal lines), and a smaller table with only about 1000 rows.

The rows in the big table contain Products (name, dates, adresses, phone numbers etc) and every product has a 'Codename' in a column-line (vertical)
of the big table. (there are about 3000-4000 products)
In the small table there exists a similar column-line (vertical) that contains 'Codenames' of the Products listed in the big table, but there are only ~ 1000 'Codenames' not the full 4000 ! The reason for this is that in the small table there exists another column-line(vertical) that for every code listed (in the small table) contains a certain specific "description".

My task is to get all the 1000 "descriptions" from the small table inserted into the Big table accordingly to their proper 'Codename'. This means createing a new column in the big table and: if the codename exists in small-table insert the description in the new column-cell, if the codename doesnt exist in small-table leave new-cell empty...

How do i do this ? :) Im guessing some coding is envolved.. and i have no clue whatsoever....
Thank you,
George P.

View 2 Replies View Related

Sub Form Increase In Size Depending On Data

Sep 29, 2006

I have a main form with a few imbedded sub forms.
Sometimes these is a great deal of data in one of the sub forms & non in the others.
Is there a way that the sub forms can grow depending on the amount of data there is in each particular sub form. (The sub form grows for a lot of data & shrinks for little data)
The way I have it now is that each sub form is always the same size and a scroll bar appears when these is extra data. This is OK but I need to see all data in sub forms at once if possible.
Can anyone help with ideas please?

View 2 Replies View Related

Large Data Imports Expanding File Size

Dec 7, 2007

Morning all,

I'm having a problem with mdb file size. I'm importing a large amount of data from a number of tab delimited text files via a simple transfertext function. The process goes: empty the tables in the database, then import the data into the tables.

All this works fine, but the file size rockets to over 1.5Gb. When I then compact and repair, it goes down to 420Mb. I'm not deleting and recreating the tables, and at no point is there 1.5Gb worth of real data, so what's causing this?

N.B. I realise I can call compact and repair following the import, but this is going to take too long as they are user-initiated imports.

View 4 Replies View Related

Reports :: Variable Report Depending On Data Size

Oct 3, 2013

I have now a report that span around 2 pages. It has subreports in the report that depening how many rows there are they can grow or shrink.I have the problem that the second page the top margin is to close to the top of the pager. The paper has a logo on the right top side. I can make the first page look nice under the logo, but the second page prints to close to the edge that prints over the logo. I did add a page break, but when the page 1 has more data, it flushes this to the next page. The page 2 is now page 3. How can I avoid that, or make it so that the margin of the second page/next page is on the correct lenght of the top. I tried it with the page setup, but it does not work.

View 3 Replies View Related

General :: Limited Size For List Box Column To Show The Data?

Feb 26, 2013

The column in my list-box did not show all the text i save in the table field. is there any limited size for list-box's column to show the data ?

View 2 Replies View Related

General :: Adjust Cell Size According To Length Of Data In Datasheet

Jul 9, 2013

I have subform (Datasheet) is there some code e.g. after update, which can adjust size cell to lenght of data?

View 11 Replies View Related

Reports :: Show Fixed Size Data In The Bottom Right Corner Of Page When Printed

Jul 3, 2015

I have a report which shows the results of two separate queries in a simple table view.

One set of data varies in size depending on the amount of records and the other is a fixed size and never changes.

I'm wanting to make my report always show the fixed size data in the bottom right corner of the page when its printed.

I've tried putting it in the footer section of the report but don't want it to affect the size of the details section and just show next to the other query results.

Is this possible and if so how would I achieve this?

View 6 Replies View Related

Tables :: Set Up Validation Of Fields Unit And Size Based On Another Fields Data?

Nov 18, 2013

Basically in my order details table i have the following fields

Product
Unit
Size

At the moment i have the Product field with a dropdown that gives me all the products from my ProductT. But once i choose the correct product in the unit field it gives me all the possibilities of every product not just the units associated with that product. ie

ProductT
Grasshopper Box1000 Adult
Grasshopper Box1000 Subadult
Worm 10pz Big

When I select the grasshopper product and move on to the unit field i also get "10pz" option but this is not a product available.

How do i set up validation of the fields Unit and size based on another fields data?

View 4 Replies View Related

DB Size

Sep 18, 2006

Hi,

What should be done when the size of a database keeps getting bigger and bigger?

Regards,
B

View 14 Replies View Related

MDB Size

May 10, 2007

I'm trying to create an mdb that is well over 2 gig and everytime it gets to 2 gig, I get an Invalid argument statement. Is there any way to bypass this process and create an mdb in excess of 2 gig? I've tried linking tables, queries, etc and I have also compacted and this mdb is simply that big.

View 14 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?

Thanks

scratch

View 4 Replies View Related

Field Size

Jun 9, 2005

I have a query that consists of three fields. This query is then placed in a form. I would like to set the physical length of my fields because one field consists of 4 digit numbers (I want the size of this to be relatively small) and the other two field consist of categories (field that need more space so that the user may see each letter of the category) Please help.

View 1 Replies View Related

Size Matters!

Jun 14, 2005

In the time-honoured fashion of reducing the size of the front end of a db I imported everything into a new db. The size reduced from 32mb to 17mb. Success.

When I change anything, no matter how small, in the new db, it immediately increases in size back to 32mb. I always compact on exit.

This is annoying, rather than a major problem.
Am I doing something wrong or is this a “feature” of Access?
Access 2000 on XP professional.

View 2 Replies View Related

Display Size

Jan 24, 2006

Is it possible when loading a control form to set the users default display size to say 1024x768. I'm creating quite a complex form and it will be too large on an 800x600 display.

Ta

View 1 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.

Thanks
Danny

View 3 Replies View Related

DB Ballooning In Size!

Apr 4, 2007

Hey guys,

I'm not sure what happened, but my database size has gone from about 60MB to 290MB. I have added about 10 new records and had an AuditTrail function keeping track of history. I had problems with too many entries in this field, so I deleted the field and started fresh. I have also tried to compact and repair the database. Can anyone give me some light on this situation?

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

Zero Size Mdb Files

Mar 11, 2008

Hi, I am new ( as of today) to this forum. I have been using Access for a few years following on from using Q&A. I manage a database for membership for a club and more recently designed my own database for another personal application. Last weekend I did a full backup on a new laptop I have that has both Access 2003 and 2007 on it ( I don't use the 2007 version at the moment) and following that most of the databases, including backups have gone to zero kb in file size. I tried a system restore to no avail. I can see the files but they are 0kb in size and won't open. Does anyone have any idea why this should happen and more importantly how (if) I can resolve it ?. The laptop has Vista as the O/S.

Kind Regards & greetings from a wet and windy Dublin,

Ian

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved