How does more than 1 user enter data w/form w/o speed issues?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff Greenwood - 23 Jan 2006 21:36 GMT

We have more than 1 user at the end of a shift that enter data. It seems that
when we have more than 1 person using the form, data entry gets very
slow....any ideas out there?

Reply to this Message

Rick B - 23 Jan 2006 22:09 GMT

I have 30 users entering data with no noticeable reduction in speed. This
is very common.

Two users should not slow down your database at all.

You could split the database and store all the data in the backend database
on the server and give each user their own copy of the front-end. This is
how you *should* do a multi-user database anyway, but I had about 10 users
in my database before I split it and we rarely had any trouble.

Signature

Rick B

> We have more than 1 user at the end of a shift that enter data. It seems
> that
> when we have more than 1 person using the form, data entry gets very
> slow....any ideas out there?

Reply to this Message

Bob Miller - 25 Jan 2006 16:41 GMT

If you are talking about opening the same form on different computers
then you need to split your database and place a front end on each
computer that will be using it. Look up split in Access help if you
are not familiar with this.
Jeff Greenwood Wrote:

> We have more than 1 user at the end of a shift that enter data. It seems
> that
> when we have more than 1 person using the form, data entry gets very
> slow....any ideas out there?

Signature

Bob Miller

Reply to this Message