Multi-user problem (1 Viewer)

[dennyryan]

I have encountered a problem when two users are accessing the same form over a network simultaneously. I modify the properties of the form within the code, i.e. Visible property of certain controls, based on the user's actions.

The problem is that the users get a message from Access indicating "Out of Memory. The form has been changed by another user" and terminates the session regrdless of how the user responds to the prompt. This only happens if a 2nd user tries to use the form simultaneoulsy.

I'm sure there must be some basic property setting that I'm missing here.

Denny

 

[Pat Hartman]

There isn't. If you want to do this type of processing, give each user a local copy of the front end database and the problem will go away.