By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,827 Members | 2,220 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,827 IT Pros & Developers. It's quick & easy.

Is 2.3 MB too big for a simple database?

P: n/a
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
Share this Question
Share on Google+
7 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.