Access lockups

K

Keelin

I have an access application that is a front end linked to a back end over a
network. I deployed the FE to the desktops of the 14 users, but the
application locks up when multiple people are accessing for extended periods
of time. There isn't much to it: 3 tables in the BE and about 3 forms. I'm
using Access 2000 and I would like to not have to unlock the database so much
(about once or twice a week depending on usage)
 
A

Albert D. Kallal

Hum, it sounds like you got the correct setup.

A few more things:

Do you distribute a mde to each user (they tend to be more reliable).
Do you have all the service packs installed for office 2000 (access 2000 is
quite flakey unless all of the updates are installed. Once done, and if
users have a mde, then things should be stable).
I would like to not have to unlock the database so much
(about once or twice a week depending on usage)
Click to expand...

Hum, what exaclty do you mean by un-lock? What are the steps you do to
un-lock? Are you talking about a workstation, or the BE?
 
K

Keelin

I haven't distributed a mde. I will look into this to get more stability.

I'm relying on the corporate IT department for updates, but I can investigate.

Normally I'm "un-locking" the BE because records aren't saving correctly, or
at all. And all I'm doing is having everyone quit the db, and compacting the
backend to get everything to normal which always works.
 
A

Albert D. Kallal

Keelin said:
I haven't distributed a mde. I will look into this to get more stability.

I'm relying on the corporate IT department for updates, but I can
investigate.

Normally I'm "un-locking" the BE because records aren't saving correctly,
or
at all. And all I'm doing is having everyone quit the db, and compacting
the
backend to get everything to normal which always works.
Click to expand...

Ok, then another thing is to check that all users have a GOOD network
connection. (no wans, or wireless etc.). You need a very SOLID connection
when you use a file share.

A list of problems, and how to prevent problems can be found here:

http://www.granite.ab.ca/access/corruptmdbs.htm
 
Top