G
Guest
Help,
I have an Access db split in to front end (10 mbytes) and backend
(30Mbytes). When the backend is local, on my C: drive, the system is really
fast. On the network, however, the database response is in excess of 60
seconds, even for a single record retrieval.
I compact & repair both db's regularly (2-3 times a week).
This is the case when I am the only user or when 3 concurrent users are on.
When I copy the database to the network drive it normally takes only 10
seconds.
The biggest table is only 15,000 rows.
Windows Task Manager reports access as 'Not responding'.
Can anyone help on this.
Many thanks in advance,
APS
I have an Access db split in to front end (10 mbytes) and backend
(30Mbytes). When the backend is local, on my C: drive, the system is really
fast. On the network, however, the database response is in excess of 60
seconds, even for a single record retrieval.
I compact & repair both db's regularly (2-3 times a week).
This is the case when I am the only user or when 3 concurrent users are on.
When I copy the database to the network drive it normally takes only 10
seconds.
The biggest table is only 15,000 rows.
Windows Task Manager reports access as 'Not responding'.
Can anyone help on this.
Many thanks in advance,
APS