Memory (helpfield) usage in Microsoft Access with VBA

pts.
Tags:
Database
IBM DB2
Microsoft Access
Oracle
VBA
Microsoft Access software is running on the desktop of every user, but the database is installed centrally on a server. More users can start and run on the same database simultaneously. In VBA I have various helpfields defined. What I want to know is: if more users are in the same part of the VBA program at the same time, will they use the same helpfield (where the helpfield is occupying space only once in memory), or will every user by default have his own (separate) part of the available memory (hence the helpfield occurs in memory as many times as there are users)? Microsoft Access 2002 SP3 Microsoft Visual Basic 6.3 Thanks in advance for your explanation.

Answer Wiki

Thanks. We'll let you know when a new response is added.

This is typical: ask a question, read it again, think it over and answer your own question.

Since every user is running on his own desktop computer, he (and she) uses the memory of his desktop, not any shared memory on the server.

However, what about a helpfield that is defined as Public ?

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following