M
Mike
Hi all,
Wasn't sure where in here to post this as it don't come
under existing Access Categories so here goes:
I have a few Access 2000 databases that live on a WinNT4
server that have become almost unbearable to use when
designing changes etc. Just to update a form field can
take up to 3 mins before being able to do anything. I have
monitored the server that these databases reside on and it
is always under 10% utilized and memory is not a prob.
These databases are not big Say 1.5MB with Approx 100
records and have been compacted etc. I have done File
transfer tests to and from the server and no problem there
either. I have virus checked the whole server (as the prob
only started approx 2 weeks ago) and no, nothing. I tested
by creating a new database in same directory with some
dummy records etc and it flys along.. I have also Opened
the databases from other machines to verify that it was
not happening as a result of something screwy on the local
PC and this made no difference still slow. When the
database is copied to local PC it goes along fast as
expected. Any suggestions would be greatly appreciated and
thanks in advance. PS there are no error messages.
Regards Mike.
Wasn't sure where in here to post this as it don't come
under existing Access Categories so here goes:
I have a few Access 2000 databases that live on a WinNT4
server that have become almost unbearable to use when
designing changes etc. Just to update a form field can
take up to 3 mins before being able to do anything. I have
monitored the server that these databases reside on and it
is always under 10% utilized and memory is not a prob.
These databases are not big Say 1.5MB with Approx 100
records and have been compacted etc. I have done File
transfer tests to and from the server and no problem there
either. I have virus checked the whole server (as the prob
only started approx 2 weeks ago) and no, nothing. I tested
by creating a new database in same directory with some
dummy records etc and it flys along.. I have also Opened
the databases from other machines to verify that it was
not happening as a result of something screwy on the local
PC and this made no difference still slow. When the
database is copied to local PC it goes along fast as
expected. Any suggestions would be greatly appreciated and
thanks in advance. PS there are no error messages.
Regards Mike.