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

ACCESS Performance

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


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

Nov 13 '05 #2

P: n/a
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.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.