forms saved automatically

[Guest]

Hi all.

I have an A2K app. with a central menu system, from which the user clicks on
the menu option and a form opens as a result (normally as a popup, non-modal
and, therefore, over the top of the main menu).
The menu(s) form uses a table as a data source, which holds the menu text
and other datum, which are used as parameters for Subs in a general
"security" module.
When a user clicks a menu option, the appropriate security Sub is called and
a comparison made to the relevant permission in the "users" table. The
resultant form is then opened, or the user is told they do not have
permission to do so.

If successful, the time taken to open the form (after menu choice) is
siginificantly increased because Access is automatically saving the main menu
(I think). Anyhow, the office assistant indicates a "save" action before
opening the chosen form.

Having looked at the form properties and code modules, I cannot find any
reason why Access is saving anything when the user chooses a menu option.
(No changes are being made to either form design, code or table).

Is there a setting somewhere (or code) that will stop this happening?
Is Access saving the underlying table? If so, why?

Any advice will be welcomed.

 

[Rick Brandt]

Hi all.

I have an A2K app. with a central menu system, from which the user
clicks on the menu option and a form opens as a result (normally as a
popup, non-modal and, therefore, over the top of the main menu).
The menu(s) form uses a table as a data source, which holds the menu
text and other datum, which are used as parameters for Subs in a
general "security" module.
When a user clicks a menu option, the appropriate security Sub is
called and a comparison made to the relevant permission in the
"users" table. The resultant form is then opened, or the user is told
they do not have permission to do so.

If successful, the time taken to open the form (after menu choice) is
siginificantly increased because Access is automatically saving the
main menu (I think). Anyhow, the office assistant indicates a "save"
action before opening the chosen form.

Having looked at the form properties and code modules, I cannot find
any reason why Access is saving anything when the user chooses a menu
option. (No changes are being made to either form design, code or
table).

Is there a setting somewhere (or code) that will stop this happening?
Is Access saving the underlying table? If so, why?

Any advice will be welcomed.

Access is not saving anything. Even if you were changing some data in the table
(doesn't sound like you are) a save would only be initiated if you were closing
the form or doing something to move to a different record. Simply executing soe
code and opening another form would not do this.

My guess would be that your security sub is what is taking the time. How much
difference is there if you bypass that? What does that code actually do?