Hi everybody!
After searching newsgroups for a couple of hours, I now try asking
directly (running the risk of asking again the same question). My
problem is to predict when the size of the database (1GB I expect) is
over 1GB by calculating the maximal number of data sets (tuple) added:
1. Is the following calculation for estimating the mdb file size in
Access 97 correct:
1 integer field = 4 Byte
1 text field (10 characters only permitted) = 10 x 1 Byte (Assumption:
Unicode 2 Byte after compression only 1 Byte) = 10 Byte
+ a certain amount of Access overhead (that's not my problem by the
way)
2. What happens to text fields internally when there is not all memory
used? E.g. text field (size: 255 characters) with no entry or only one
character. Is the full memory reserved anyway or does Access 97
recognise that no data is in and doesn't use all the memory?
THANK YOU SO MUCH!
All the best,
Stephan Kuhnert 2 2534
Access only uses as much space for text fields as is required. This is
easily proven. Create a table that has 10 text fields, each of 255 bytes. In
theory, that exceeds the allowable row size, however, you won't get an error
until after you try to store the 2001st character.
Yes, an Integer in Access is 4 bytes.
I don't believe Access 97 supports Unicode, so that's a non-issue.
Don't forget that indexes take up part of the 1Gb.
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
"kuhni" <st************ @gmx.de> wrote in message
news:88******** *************** ***@posting.goo gle.com... Hi everybody!
After searching newsgroups for a couple of hours, I now try asking directly (running the risk of asking again the same question). My problem is to predict when the size of the database (1GB I expect) is over 1GB by calculating the maximal number of data sets (tuple) added:
1. Is the following calculation for estimating the mdb file size in Access 97 correct: 1 integer field = 4 Byte 1 text field (10 characters only permitted) = 10 x 1 Byte (Assumption: Unicode 2 Byte after compression only 1 Byte) = 10 Byte + a certain amount of Access overhead (that's not my problem by the way)
2. What happens to text fields internally when there is not all memory used? E.g. text field (size: 255 characters) with no entry or only one character. Is the full memory reserved anyway or does Access 97 recognise that no data is in and doesn't use all the memory?
THANK YOU SO MUCH!
All the best, Stephan Kuhnert
If you know now that your data will exceed 1 gig, then Jet is not the tool
for you. Try Oracle or SOL.
-Ed
"kuhni" <st************ @gmx.de> wrote in message
news:88******** *************** ***@posting.goo gle.com... Hi everybody!
After searching newsgroups for a couple of hours, I now try asking directly (running the risk of asking again the same question). My problem is to predict when the size of the database (1GB I expect) is over 1GB by calculating the maximal number of data sets (tuple) added:
1. Is the following calculation for estimating the mdb file size in Access 97 correct: 1 integer field = 4 Byte 1 text field (10 characters only permitted) = 10 x 1 Byte (Assumption: Unicode 2 Byte after compression only 1 Byte) = 10 Byte + a certain amount of Access overhead (that's not my problem by the way)
2. What happens to text fields internally when there is not all memory used? E.g. text field (size: 255 characters) with no entry or only one character. Is the full memory reserved anyway or does Access 97 recognise that no data is in and doesn't use all the memory?
THANK YOU SO MUCH!
All the best, Stephan Kuhnert This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: kie |
last post by:
hello,
i have a table that creates and deletes rows dynamically using
createElement, appendChild, removeChild.
when i have added the required amount of rows and input my data, i
would like to calculate the totals in each row.
when i try however, i receive the error:
"Error: 'elements' is null or not an object"
|
by: Yannick Turgeon |
last post by:
Hello,
We are in the process of examining our current main application. We have to
do some major changes and, in the process, are questionning/validating the
use of MS Access as front-end. The application is relatively big: around 200
tables, 200 forms and sub-forms, 150 queries and 150 repports, 5GB of data
(SQL Server 2000), 40 users.
I'm wondering what are the disadvantages of using Access as front-end? Other
that it's not...
|
by: dog |
last post by:
I've seen plenty of articles on this topic but none of them have been
able to solve my problem.
I am working with an Access 97 database on an NT4.0 machine, which has
many Access reports.
I want my users to be able to select a report, click on a command
button on a form, which will then automatically create the report as a
pdf file and save it to the user's machine.
I am using Adobe Acrobat (5.0 I think) and have Adobe Distiller as a
|
by: Grasshopper |
last post by:
Hi,
I am automating Access reports to PDF using PDF Writer 6.0. I've
created a DTS package to run the reports and schedule a job to run this
DTS package. If I PC Anywhere into the server on where the job is
running, the job runs sucessfully, PDF files got generated, everything
is good. If I scheduled the job to run at the time that I am not
logged into the server, Access is not able to print to the printer.
The error is pretty...
|
by: doomx |
last post by:
I'm using SQL scripts to create and alter tables in my DB
I want to know if it's possible to fill the description(like in the
Create table UI) using these scripts.
EX:
CREATE TABLE(
Pk_myPrimaryKey INTEGER CONSTRAINT pk PRIMARY KEY DESCRIPTION 'This
is the primary key of the table',
| |
by: luscus |
last post by:
Thanks for all the responses on my first question. Unfortunately the
answers I was given were too complicated for my small brain , and
neophite condition to understand. So if you could talk down to me and
write in easier terms I would be very gratefull to all you access
wizards!
Here is my problem. I have a table with maybe 10 fields, It is used to
imput information taken over the phone to solve patient problems in our
Spanish...
|
by: TheCoder |
last post by:
I am making a D-base with web conectivity for my class project. I have
everything working but the subit button sends the data to the correct
fields but afterwards it wants to reproduce new blank text boxes how do
I stop this and how would I code it to redirect to a thank you page.
All with out the help of a web server this has to br ran from the
desktop and with in IE with a local directory. Pleas help I am stuck.
here is the code!
...
|
by: alexandre.brisebois |
last post by:
Hi, I am using access 2003, I would like to know if there is an option
to reorganize the tables in a maner that is readable, as we can do in
sql sever 2000 or 2005.
I have been given a database to look a and I am loosing tremendious
amounts of time trying to organize it so that I could view it.
Regards,
Alexandre Brisebois
|
by: hyperpau |
last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding.
I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com).
Ergo, I will be writing this article intended for those who are in the same level, or maybe lower, of my technical knowledge.
I would be using layman's words, or maybe, my own words as how I understand them, hoping, you will understand it the same way that...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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...
| |