Application slows down on input of items sold

[jkafer]

I'm having a problem with an application that I wrote for a 4H garage sale.

Here are the basics:
Access 2003 - compiled into an mde
Database is split, database is sitting on PC and shared
Frontend is run off desktops of other computers
We have up to 5 computers inputting data

The problem comes when selling items.
I have a form with a sub-form.
SubFrom has only 1 entry field on it with a drop down
When entering the ticket #, it has to be in the list of the drop down.
Drop down refreshes so that you can not select an item after it's sold
and incase anything has been added to the list of available items.
Then a record is added to the tblMerchActivity table with
The ticket#, Description, price
(these are the three fields that show in the drop down)
This table allows no duplicates in the Ticket # field
When the record is added - the person has to verify that the
info matches the info on the ticket.

1-2 people working on this, it works great.
3+ and it starts to slow down greatly.
Forget having 5, it can take up to 30 seconds for each entry.

Can anyone think of any way to do this differently that would speed it up?

 

[RuralGuy]

Try a persistant connection.

http://www.granite.ab.ca/access/performancefaq.htm

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit