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.
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.