Dear all,
I don't know if my question is Access Version related specific or
applies to any, anyway here it is:
Regarding Access performance, memory consuming resources, etc., which
is better? ...
.. to have a "hide" form with, let's say, 50 fields to store values to
exchange information among forms, queries, reports, etc. while
application is up.
.. ... or to have 50 public memory variables.
Thanks in advance.
Angel. 2 1438
The variables will use less memory and be faster to access than the form,
but when users have hundreds of MB of RAM and gigahz of CPU speed, the
difference is probably mimimal.
The values in the hidden form are easier to develop and debug, i.e. they are
not lost every time you reset your project during development. Additionally,
you can use the Close event of the hidden form to simulate an application
close event.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"amazo" <am***@pobladores.com> wrote in message
news:4c*************************@posting.google.co m... I don't know if my question is Access Version related specific or applies to any, anyway here it is:
Regarding Access performance, memory consuming resources, etc., which is better? ...
. to have a "hide" form with, let's say, 50 fields to store values to exchange information among forms, queries, reports, etc. while application is up.
. ... or to have 50 public memory variables.
Thanks in advance.
Angel.
amazo wrote: Dear all,
I don't know if my question is Access Version related specific or applies to any, anyway here it is:
Regarding Access performance, memory consuming resources, etc., which is better? ...
. to have a "hide" form with, let's say, 50 fields to store values to exchange information among forms, queries, reports, etc. while application is up.
. ... or to have 50 public memory variables.
Thanks in advance.
Angel.
I usually have a table, something like AppVariables. 1 record, a bunch
of fields. That works fine.
If you use variables, none of your code can error out to Debug/End mode.
If that happens, you need to reset the variables. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: WalterR |
last post by:
This is my first time here, so there may be earlier relevant threads of
which I am unaware. Though my experience with DB2 is not extensive,
such as it is was under OS/390 or equ. My main...
|
by: John |
last post by:
Hi,
I've recently upgraded from Access 97 to Access 2002 & the performance
basically stinks. I have tried the following items listed below but it
has only had a minor impact:
1) Upgraded Jet...
|
by: Terry Bell |
last post by:
We've had a very large A97 app running fine for the last seven years.
I've just converted to SQL Server backend, which is being tested, but
meanwhile the JET based version, running under terminal...
|
by: Tony Lee |
last post by:
Some time a ago, on this newsgroup the following comments were made in
recommending
good references for Access (2003)
>I used to recommend Dr. Rick Dobson's, "Programming Access <version>" for...
|
by: Bob Alston |
last post by:
Most of my Access database implementations have been fairly small in
terms of data volume and number of concurrent users. So far I haven't
had performance issues to worry about. <knock on wood>
...
|
by: lgbjr |
last post by:
Hello All,
I've been developing a VB.NET app that requires the use of a DB. Up to now,
I've been using Access. It's a bit slow, but everything works. I'm at a
point now where I need to decide if...
|
by: DaveG |
last post by:
Hi all
I am planning on writing a stock and accounts program for the family
business, I understand this is likely to take close to 2 years to
accomplish. The stock is likely to run into over a...
|
by: egoldthwait |
last post by:
I need to convert a 17mb access 2000 db to Oracle and house it in a
Citrix farm. The issue: we have never converted an Access Db to Oracle
but can probably use Oracle's Workbench to assist with...
|
by: onnodb |
last post by:
Hi all,
While working on an Access UI to a MySQL database (which should be a
reasonable, low-cost, flexible interface to the DB, better than
web-based, much less costly than a full-fledged .NET...
|
by: dorpnospam |
last post by:
We have an old but very critical application that was written in VB 6
against Access 95 dbs. We need to ditch this decrepit old unstable db
platform but we are trying to determine the best...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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,...
|
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...
|
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...
| |