Data access over network very slow (1 Viewer)

[AliyuKatsina]

Hi.,
I developed a software for managing Junior Secondary School Examination using access 2010. Total number of registered candidates were less than 60,000.

I split the db into back-end and runtime front-end. I distributed the front-end to various local clients for entry of examination marks. I used the recordset object for editing records.

Whenever more than 2 clients are updating entering marks the software slows down terribly.

Any solution or is it Access itself?

 

[jdraw]

see this article

and this one

and another http://www.kallal.ca/Articles/split/

There are a number of posts on different forums related to performance on networks.

Good luck. Please let us know if you find some good tips for solution--it is a common issue.