Are there ny guidelines for using space usage with ASP/Access?
I have an Access 2000 DB on shared Web space, which is 2MB but
growing, and soon to reach about 10MB due to a catalog change. My host
places a normal limit of 10MB before an upgrade is needed to more
space. Now I have no response issues, but I am planning.
Currently about 400 users a day visit, but this should increase as the
the catalog grows (now 14 lines, set to go to 100). Visitors use the
catalog for price checks, shopping cart, and online ordering uses the
same DB (no CC are held).
I am wondering if a space/memory guideline exists for using Access,
and when an upgrade to SQL Server 2000 is needed.
Can anyone shine light on this topic?
3  9612 
Well, Access97 had a 1GB limit so I think you're safe. Your number of users
in a day is irrelevant... number of simultaneous users is the important
thing.
D.
"Trevor" <sa***@logician s.com> wrote in message
news:88******** *************** ***@posting.goo gle.com... Are there ny guidelines for using space usage with ASP/Access?
I have an Access 2000 DB on shared Web space, which is 2MB but
growing, and soon to reach about 10MB due to a catalog change. My host
places a normal limit of 10MB before an upgrade is needed to more
space. Now I have no response issues, but I am planning.
Currently about 400 users a day visit, but this should increase as the
the catalog grows (now 14 lines, set to go to 100). Visitors use the
catalog for price checks, shopping cart, and online ordering uses the
same DB (no CC are held).
I am wondering if a space/memory guideline exists for using Access,
and when an upgrade to SQL Server 2000 is needed.
Can anyone shine light on this topic?
The Jet database engine that comes with Access 2000 and later versions has a
maximum size of 2GB, but you can use larger amounts of data by using
multiple databases with linked tables. Size alone is rarely, if ever, a
valid reason for moving from a Jet (aka Access) database to a server
database.
Jet databases tend to grow as they are used, because space vacated by
deleted records, deleted database objects, and internally created workspace
is not recovered until the database is Compacted. So, you may be able to
shrink your database substantially simply by opening Access, and on the
database window, Tools | Database Utilities | Compact and Repair.
The same limit applies to the Microsoft Database Engine (MSDE) aka Microsoft
SQL Server Desktop that comes free with Access, but must be installed
separately.
Larry Linson
Microsoft Access MVP
"Trevor" <sa***@logician s.com> wrote in message
news:88******** *************** ***@posting.goo gle.com... Are there ny guidelines for using space usage with ASP/Access?
I have an Access 2000 DB on shared Web space, which is 2MB but
growing, and soon to reach about 10MB due to a catalog change. My host
places a normal limit of 10MB before an upgrade is needed to more
space. Now I have no response issues, but I am planning.
Currently about 400 users a day visit, but this should increase as the
the catalog grows (now 14 lines, set to go to 100). Visitors use the
catalog for price checks, shopping cart, and online ordering uses the
same DB (no CC are held).
I am wondering if a space/memory guideline exists for using Access,
and when an upgrade to SQL Server 2000 is needed.
Can anyone shine light on this topic?
I should add... that's 1GB for a MDB. You can link to multiple MDBs.
D.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: kuhni |
last post by:
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
|
by: Ron |
last post by:
Hi all,
How do I determine the size of the tables I'm using? I looked under
properties and it's not there. The book I just browsed said table is
limited to 1GB. How do I find out what size my tables are?
TIA
ron
|
by: Knick via AccessMonster.com |
last post by:
I am novice to MS Access Development,
I regularly back my access database every 2, 3 days ...today when I was
going to back my database I saw the access file on the network drive was only
9 MB in size, while the backup files that I had saved few days back were 258
MB in size.
And the network drive is where the database is saved on.
Can anyone suggest something why or how I can track what happend or a way to
|
by: John |
last post by:
Hi
I have a typical front end/back end access app. Additionally a vb.net app
accesses the backend mdb file every few minutes and runs insert and update
queries on some table. The data to be inserted and updated is coming from a
remote db. The mdb file size is normally around 80MB but since running the
vb.net app the mdb file size grows to 1GB or so every few days. After
compact and repair the size does get back to 80MB but it is still a...
|
by: mast2as |
last post by:
This question has been posted to this forum before and I read the
thread but found that the answers were perhaps imcomplete, so I am
trying again.
Whenever I am creating objects I would like to keep track of the
memory which is used for each object (for stats purpose). They are 2
basic approaches, one is to write a Memory manager type of class where
new & delete would be overloading the standard new & delete operator.
Each time the new...
| | |
by: colmkav |
last post by:
Can someone tell me how to check the size of an access database in VB
code?
I want to write code to check the size and then compact it if it is
greater than this size.
|
by: Ian |
last post by:
I am trying to get MS Access 2000 to print names and addresses onto a
Dymo 400 label printer, I have set the Access Report to automatically
select the correct printer, then select the label size of “99012 Large
Address”.
This works fine but when I move my database to another PC (with
identical Dymo printer and drivers) the report defaults to the correct
printer but does not select the label “99012 Large Address”. On
different PC’s it...
|
by: sphinney |
last post by:
My company is in the process of upgrading everyone to Access 2007. Since my machine was upgraded I've been highly frustrated with an apparent random behaviour byAccess that I can't understand. It involves databases that I created in Access 2002 (i.e. *.mdb files).
What happens is when I open a form that has the border style property set to 'Dialog', Access 2007 is correctly preserving the size of the form itself (i.e. if you look in the...
|
by: leegold58 |
last post by:
Hi,
Is there a "way around" the size limitation for Access? I'm thinking
of something like spanning a huge table accross multiple databases...
Something simple and that would preserve the integrity of the DB yet
let me overcome the size limitation.
Is there any best practice or technique?
|
by: Adam Chapman |
last post by:
Hi,
Im trying to migrate from programming in Matlab over to C. Im trying
to make a simple function to multiply one matrix by the other. I've
realised that C can't determine the size of a 2d array, so im
inputting the dimensions of those myself.
The problem is that the output array (C=A*B) has as many rows as A and
as many columns as B. I would think of initialising C with:
|
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: 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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
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...
| |
