delayed keystrokes with multiple users

[EdiebAZ]

My department is using Access as shadow bookkeeping, we have multiple users
but no more than five users at a time. They use a data enty form, but when
doing a entry the keystrokes are delayed as much as five seconds to type in
the field or tab to the next field. How do we eliminate this? The strokes
seem not live. It is very annoying when trying to reconcile.

 

[EdiebAZ]

Is your database split? If you've got multiple-users entering data, you need
to have you database split into front end and back end. Each user needs to
have a copy of the front end on their PC, with a copy of the back end on a
server. Users sharing a front end can cause all kinds of problems, including
repeated corruption.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com


Forgot big information, we are using Office Professional 2007.

 

[Klatuu]

The answer is still the same. Multiple users should never share the same
copy of an Access application, regardless of version.
As Linq stated, it makes it slow because it is having to service multiple
users, it is jamming up your network with way too much traffic, and you can
expect corruption.

There are many other reasons to split the database. For example, you will
find out quickly when you need to make changes to the application what a
headache it can be to keep the data in sync.

So, do it the right way. Split the database, put the _be file (the data) on
the server where each user has read/write/delete permissions, and put a copy
of the application on each user's computer. Believe me, you will save
yourself a lot of grief if you do it this way.

 

[EdiebAZ]

Thank you. Our next step is to split the database to front and back end. I
was just hoping for a quick fix, silly me this is Access.

 

[Klatuu]

Splitting a database doesn't take that long and believe me, this is the quick
fix.