Multi Users Access database gets Inactive

[Drunkenneo]

I have a multiuser data entry form which on using somtimes gets inactive, means the button stop working and we have to close the form and open again to avoid. Does anyone have any idea whet to be taken care?

 

[David R]

What do you mean by "inactive"? Are you sure it's not a network drop?

 

[Drunkenneo]

It is clicking on any buttons on forms is not functioning, means no save, no refresh and nothing...

There may be chance of network drop, but if network is not dropped then what are the chance and how can we rectify it..

 

[Mihail]

If this happen only for this form try this:
Create a new (empty) form.
Copy all objects from actual form into this new one.
Copy all the code from the actual form module into this new one.

Refresh all events, for all controls that fired an event if your version of Access can't do this by itself (2007 can't and this should be a bug)

Remove your old form and rename this new one.

Do a try. Before this, ask God that this time to work better.