I am having a problem with my app slowing to a crawl and finally locking up
when more than 2 users are working with it at the same time. This takes
place over about 30 min. to an hours time. They say it takes 45 min. to
become available again. I'm using an Access 2000 database that is currently
about 85 MB in size. They are adding 50 to 75 records an hour. I connect
using ADO 2.7 and MS Jet.4.0 OLEDB provider. I use a middle tier dll to
handle all requests for data form the app. All workstations on the system
are running XP. I've run this on my system with 2 users and the customer's
database and experienced no slowdown at all after an hour of use. At this
point I don't know if it is there system or my code. The trouble is that
they are my only installation that uses more than 3 people on the system at
a time so I can't say that it is running great anyplace else.
Any Ideas?
Thanks,
Dave