473,327 Members | 1,919 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Is 2.3 MB too big for a simple database?

I am a relative newcomer to database applications and am in the
process of creating a simple database which tracks Student Details and
Exams.

My database has:

3 Tables (about 100 records in total)
4 Queries, 5 Forms (one of which is a Main Switchboard)
3 Reports, 2 Macros
2 very small VB6 codes
and quie a bit of conditional formatting

My database doesn't include any OLE objects. I looked at the
Properties of Northwind and was amazed to see that it is only 2.2 MB.

I have been tweeking my database a lot and wonder if things I have
deleted and/or changed or have somehow somehow remained, hidden within
the database.

Which objects/codes take up most memory?

Terry
Nov 12 '05 #1
7 2693
Try compacting your database.

Any objects you have created and deleted, or records added and deleted do
not decrease the size of the database until it is compacted.

Terry
"Terry" <tc*****@merseymail.com> wrote in message
news:38*************************@posting.google.co m...
I am a relative newcomer to database applications and am in the
process of creating a simple database which tracks Student Details and
Exams.

My database has:

3 Tables (about 100 records in total)
4 Queries, 5 Forms (one of which is a Main Switchboard)
3 Reports, 2 Macros
2 very small VB6 codes
and quie a bit of conditional formatting

My database doesn't include any OLE objects. I looked at the
Properties of Northwind and was amazed to see that it is only 2.2 MB.

I have been tweeking my database a lot and wonder if things I have
deleted and/or changed or have somehow somehow remained, hidden within
the database.

Which objects/codes take up most memory?

Terry

Nov 12 '05 #2
Have you compacted it

Tools>Database Utilities>Compact Database

This makes a big difference...
"Terry" <tc*****@merseymail.com> wrote in message
news:38*************************@posting.google.co m...
I am a relative newcomer to database applications and am in the
process of creating a simple database which tracks Student Details and
Exams.

My database has:

3 Tables (about 100 records in total)
4 Queries, 5 Forms (one of which is a Main Switchboard)
3 Reports, 2 Macros
2 very small VB6 codes
and quie a bit of conditional formatting

My database doesn't include any OLE objects. I looked at the
Properties of Northwind and was amazed to see that it is only 2.2 MB.

I have been tweeking my database a lot and wonder if things I have
deleted and/or changed or have somehow somehow remained, hidden within
the database.

Which objects/codes take up most memory?

Terry

Nov 12 '05 #3
In article <38*************************@posting.google.com> ,
tc*****@merseymail.com says...
I am a relative newcomer to database applications and am in the
process of creating a simple database which tracks Student Details and
Exams.

My database has:

3 Tables (about 100 records in total)
4 Queries, 5 Forms (one of which is a Main Switchboard)
3 Reports, 2 Macros
2 very small VB6 codes
and quie a bit of conditional formatting

My database doesn't include any OLE objects. I looked at the
Properties of Northwind and was amazed to see that it is only 2.2 MB.

I have been tweeking my database a lot and wonder if things I have
deleted and/or changed or have somehow somehow remained, hidden within
the database.

Which objects/codes take up most memory?

Terry

You are mixing terms here. The file size of 2.3MB is not the same as
the memory it takes to run. What you want to know (if concerned with
the 2.3MB file size) is which object take up most disk space. Having
said that, try compacting the DB and see if that helps.
Nov 12 '05 #4
TC
That is not an excessive size. But as the others have said, try compacting
it anyway.

HTH,
TC
"Terry" <tc*****@merseymail.com> wrote in message
news:38*************************@posting.google.co m...
I am a relative newcomer to database applications and am in the
process of creating a simple database which tracks Student Details and
Exams.

My database has:

3 Tables (about 100 records in total)
4 Queries, 5 Forms (one of which is a Main Switchboard)
3 Reports, 2 Macros
2 very small VB6 codes
and quie a bit of conditional formatting

My database doesn't include any OLE objects. I looked at the
Properties of Northwind and was amazed to see that it is only 2.2 MB.

I have been tweeking my database a lot and wonder if things I have
deleted and/or changed or have somehow somehow remained, hidden within
the database.

Which objects/codes take up most memory?

Terry

Nov 12 '05 #5
Ima Lostsoul <me@myprovider.com> wrote in message news:<MP************************@netnews.comcast.n et>...
In article <38*************************@posting.google.com> ,
tc*****@merseymail.com says...
I am a relative newcomer to database applications and am in the
process of creating a simple database which tracks Student Details and
Exams.

My database has:

3 Tables (about 100 records in total)
4 Queries, 5 Forms (one of which is a Main Switchboard)
3 Reports, 2 Macros
2 very small VB6 codes
and quie a bit of conditional formatting

My database doesn't include any OLE objects. I looked at the
Properties of Northwind and was amazed to see that it is only 2.2 MB.

I have been tweeking my database a lot and wonder if things I have
deleted and/or changed or have somehow somehow remained, hidden within
the database.

Which objects/codes take up most memory?

Terry

You are mixing terms here. The file size of 2.3MB is not the same as
the memory it takes to run. What you want to know (if concerned with
the 2.3MB file size) is which object take up most disk space. Having
said that, try compacting the DB and see if that helps.


Amazing! I compacted it and it is now 625KB. So which objects do take
up the most space?
Nov 12 '05 #6
Erm, actually you are wrong here when talking about memory.

Memory (for a computer) consists of ROM, RAM and storage. So when Terry
referred to the file size as taking up memory they were technically correct.
Terry (Kreft)
"Ima Lostsoul" <me@myprovider.com> wrote in message
news:MP************************@netnews.comcast.ne t...
In article <38*************************@posting.google.com> ,
tc*****@merseymail.com says...
I am a relative newcomer to database applications and am in the
process of creating a simple database which tracks Student Details and
Exams.

My database has:

3 Tables (about 100 records in total)
4 Queries, 5 Forms (one of which is a Main Switchboard)
3 Reports, 2 Macros
2 very small VB6 codes
and quie a bit of conditional formatting

My database doesn't include any OLE objects. I looked at the
Properties of Northwind and was amazed to see that it is only 2.2 MB.

I have been tweeking my database a lot and wonder if things I have
deleted and/or changed or have somehow somehow remained, hidden within
the database.

Which objects/codes take up most memory?

Terry

You are mixing terms here. The file size of 2.3MB is not the same as
the memory it takes to run. What you want to know (if concerned with
the 2.3MB file size) is which object take up most disk space. Having
said that, try compacting the DB and see if that helps.

Nov 12 '05 #7
In article <To********************@karoo.co.uk>, te*********@mps.co.uk
says...
Erm, actually you are wrong here when talking about memory.

Memory (for a computer) consists of ROM, RAM and storage. So when Terry
referred to the file size as taking up memory they were technically correct.
Terry (Kreft)
"Ima Lostsoul" <me@myprovider.com> wrote in message
news:MP************************@netnews.comcast.ne t...
In article <38*************************@posting.google.com> ,
tc*****@merseymail.com says...
I am a relative newcomer to database applications and am in the
process of creating a simple database which tracks Student Details and
Exams.

My database has:

3 Tables (about 100 records in total)
4 Queries, 5 Forms (one of which is a Main Switchboard)
3 Reports, 2 Macros
2 very small VB6 codes
and quie a bit of conditional formatting

My database doesn't include any OLE objects. I looked at the
Properties of Northwind and was amazed to see that it is only 2.2 MB.

I have been tweeking my database a lot and wonder if things I have
deleted and/or changed or have somehow somehow remained, hidden within
the database.

Which objects/codes take up most memory?

Terry

You are mixing terms here. The file size of 2.3MB is not the same as
the memory it takes to run. What you want to know (if concerned with
the 2.3MB file size) is which object take up most disk space. Having
said that, try compacting the DB and see if that helps.


You have a system that has 1GB RAM and 180GB HD. Someone asks how much
memory you have in your computer. Your arnswer is 1GB.

Go to any computer store and tell them you want to buy 180GB of memory.
They will look at you as if you were a loon. Then they will direct you
DRAM, etc.

Go to pricewatch.com search under memory. No hard drives there.

By a pure textbook definition from the 80s you may have a semi-valid
point. For use in the real world HD storage is not memory.

Nov 12 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Fuzzyman | last post by:
I'm looking to build a simple database application for use on the desktop (customer contact and feedback database). Anyone able to reccomend a simple module / package I can use... ? I've never...
1
by: Simon Roses Femerling | last post by:
Thx for your response sqllite looks very interesting :) Here is the python module: http://sourceforge.net/projects/pysqlite/ I'm familiar with mysql and postgresql but there are too heavy and...
1
by: channa_s | last post by:
Hi, I would be very grateful if anyone could help me with the following. I want to create a SIMPLE distributed database. It is as follows: There is a institution which has branches all...
9
by: Pete | last post by:
Does anyone have a simple html vbscript or other type of snippet they can share that appends a record to a access database via ADO or DAO? I would like to allow users that don't have Microsoft...
2
by: Ryan McBride | last post by:
Once again at my wonderful job i've been given the task of "come teach your fellow idiot coworkers the skills you have" I write software for a company in chicago. I use visual basic on asp.net...
10
by: serge calderara | last post by:
Dear all, I need to build a web application which will contains articles (long or short) I was wondering on what is the correct way to retrive those article on web page. In orther words, when...
10
by: Andrew | last post by:
Sorry about this but I'm new to ADO.NET (finally coming from simple ADO, bless it) and I'm trying to create a simple three tier program. Ie, User interface Layer / Business object layer / Database...
2
by: Brad | last post by:
Where is the connection string stored for a simple Crystal Report Application. What I am trying to do is: 1. Create a simple report from a Firebird database using an ODBC connection 2. Need to...
2
by: samadams_2006 | last post by:
I'm trying to get a simple VB.NET "Web Application" (not a regular application) to work with an Access Database. Seems simple enough, but I cannot seem to get it working. If anyone has a simple...
7
by: CSharper | last post by:
Yesterday I had a heated discussion with my colleagues on what is a data centric application and having business logic in sql. I have group of people who wants to include all the business logic in...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.