I have an Access 2000 database where the backend resides
on the network (mapped as Z:\) and the frontend resides on
each users PC.
Users log on to the database and are then presented with
their user-type front screen. On the whole this process
completes in a few seconds but I have a sporadic problem
which I can't pin down.
Occasionally the application will be very slow to show the
logon dialog box, user logs on and again there is
significant delay in showing the user front screen. Once
this displays the application 'locks' and the user is
unable to push any of the buttons or use the menu items.
The only way to close the application is to go to task
manager and end task. Incidentally, task manager shows
the application as "running" and CPU activity is minimal.
I've tried leaving the application open to see if it
manages to regain control after a period of time but
haven't managed to do this as yet.
General network performance is good and when the problem
doesn't happen overall application performance is
excellent.
Any ideas? I really need to solve this one but I'm
stumped!
Thanks,
Fiona
Nikos Yannacopoulos - 29 Sep 2004 10:59 GMT
Fiona,
Check out some useful tricks on performance in Tony Toews' page:
http://www.granite.ab.ca/access/performancefaq.htm
They have proved to be extremely useful in similar situations, assuming of
course your problem is a performance one rather than a network outage one.
HTH,
Nikos
> I have an Access 2000 database where the backend resides
> on the network (mapped as Z:\) and the frontend resides on
[quoted text clipped - 27 lines]
>
> Fiona
Fiona Ross - 29 Sep 2004 12:26 GMT
Thanks for this - I've checked through and I seem to be complying.
I've not managed to find any info on my specific issue - access is running
and the form has opened but it all just stops and never comes back. Has
anyone else experienced this situation?
Fiona
Nikos Yannacopoulos - 29 Sep 2004 11:04 GMT
Fiona,
Another important thing to do is to change the links to the back-end form
Z:\Whatever to a UNC address (\\ServerName\Whatever). It may be that some
users, whether intentionally or not, change the mapping, so the connection
is lost.
HTH,
Nikos
> I have an Access 2000 database where the backend resides
> on the network (mapped as Z:\) and the frontend resides on
[quoted text clipped - 27 lines]
>
> Fiona
Fiona Ross - 29 Sep 2004 12:14 GMT
The drive mapping isn't the problem - the users aren't actually able to
change the mapping and from reading some other articles direct drive mapping
appears to be quicker than UNC.
Fiona
> Fiona,
>
[quoted text clipped - 37 lines]
> >
> > Fiona