Application Very Slow

  • Thread starter DineshLiyanage via AccessMonster.com
  • Start date
D

DineshLiyanage via AccessMonster.com

I am using Access 2003 FE & BE application. My BE is in the server and about
15 Nos of simultanious users accessing the database with FE (MDE format)
application which is on there own Pc's. For almost all recordset operations I
have used "db.OpenRecordset("", dbOpenDynaset)" type in my FE application. If
only one user is using the application, then it is very fast and just after
any of other user logged on to the system then the whole application
performance dropping down considerably. And also two users are not using the
same form as well as not using the same tables (Directly) . I want to speed
up this application. I am sure this is not because of netwark problem and
also my database size is just 200mb and I am not having too many records in
tables.Can anybody please help me to sort out this issue.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top