Main form causing multiple errors

[malspa]

History: I have created a database for my company to track all
incidents, equipment issues, and more. The database has been in use
for over a year and has been working quite well. It is a split
database with the back end located on a network hard drive and the
front end updated through autofeupdate. The database is setup for a
multiuser environment. I have integrated functions to send email
messages and create reports daily. Recently, I have added six list
boxes to the main form. Each listbox displays information on current
records. For instance, one listbox shows all the open equipment
tickets we have. Another listbox shows all the recent incidents we
have had. To ensure that current information is shown, I have the main
form timer set to 1 minute and am performing a requery on each
listbox.

Issue: Since I have added the six listboxes I have been experiencing a
multitude of errors. Although this has provided me with an abundance
of overtime, it has had a negative effect on my family. The errors
have included: corruption of the back end, denial of access due to
another user having exclusive privileges, and denial of access due to
another user using the table. Does anyone have any suggestions? I
would like to find a way to keep the listboxes on the main form.

 

[Albert D. Kallal]

So, the front is placed on each pc then...correct?


Do you distribute a mde to the users? I would try that...it more stable then
mdb...

 

[malspa]

So, the front is placed on each pc then...correct?

The front end is placed on each pc. After I update the version on the
network drive, the updated version will be downloaded to each pc when
opened.

Do you distribute a mde to the users? I would try that...it more stable then
mdb...

Will all the VBA coding work the same in a mde as it does in an mdb?

 

[Albert D. Kallal]

Will all the VBA coding work the same in a mde as it does in an mdb?

Yes, and it tends to be more reliable.

It very possible that your problems are due to when you launch a form, your
still have the "timer" code running below, or all the time...

You might consider have a form that you open...and it can "display" this
information as you have. However, make the form model (not dialog), and thus
the user will have to "close" this form to use the rest of the
application...

Doing those constant requery while trying to run other parts of the
application might be problematic...