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
7  2701 
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*****@mersey mail.com> wrote in message
news:38******** *************** **@posting.goog le.com... 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
Have you compacted it
Tools>Database Utilities>Compa ct Database
This makes a big difference...
"Terry" <tc*****@mersey mail.com> wrote in message
news:38******** *************** **@posting.goog le.com... 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
In article <38************ *************@p osting.google.c om>, tc*****@merseym ail.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.
That is not an excessive size. But as the others have said, try compacting
it anyway.
HTH,
TC
"Terry" <tc*****@mersey mail.com> wrote in message
news:38******** *************** **@posting.goog le.com... 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
Ima Lostsoul <me@myprovider. com> wrote in message news:<MP******* *************** **@netnews.comc ast.net>... In article <38************ *************@p osting.google.c om>,
tc*****@merseym ail.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?
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.comca st.net... In article <38************ *************@p osting.google.c om>,
tc*****@merseym ail.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.
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.comca st.net... In article <38************ *************@p osting.google.c om>,
tc*****@merseym ail.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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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 done any database work before and am ken to learn - but
most of the ones I've seen seem to rely on a database engine buit into
a server.. I need a simple stand alone engine. Of course I could just
build the functions I need - but that would be a...
|
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 I dont want to install a database.
I'm looking for something like sqllite
thx
|
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 over the country offering
|
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 Access a way of
adding records to a access database from a simple web page. I don't
want to have to setup ODBC or anything like that I just want to put
the web page on the network for anyone to access. Most of the users
would use the local access...
|
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
type platform.
Recently i learned a little bit on database access and would like to knw
more so that i can pass along the knowledge to my coworkers who do not
possess this information. the trouble is that my code is very sloppy and
I'm not...
| | |
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 there is such information to be displayed are they
coming from imported files, database ?
Where and how this type of information is stored ?
What is the way to retrieve such information in order to display it in page ?
|
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 layer
I've got a simple program that is activilly populating and writing my
satasets. They are currently only mapping the database tables.So 1 dataset,
5 datatables and several relationships.
In this program I can't seem to hide the database...
|
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 compile and deploy to a production environment
3. How to set the data connection so it is can connect to the production
database which is different to the dev database...this must be able to be
done on the production system after compiling on the...
|
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 example that
they can send me it would be very much appreciated. Drop me an email
at: samadams_2006@yahoo.ca
Thanks...
|
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 the sql
stored proc and I for one consider to have most of the business logic
in the C# code (specifically in a controller class of MVC). These are
my points to them.
1. Our application depends a lot on the data and we have huge amount
of data...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
