Secure Database is Slow on the LAN

  • Thread starter Thread starter fred
  • Start date Start date
F

fred

I converted an application to a secure database on our
LAN. Now there are certain forms that are very, very
slow to load (around 90 seconds or more). Once loaded
they are OK.

Everything was OK before I made it secure. I set it up
on my local computer and everything is OK there.

Any suggestions?
 
At application startup time, I would open a recordset to a back end table,
and LEAVE it open.

Now, try your application...it should perform as before....

I as a rule have not noticed any drop in performance when using a secured
database. However, likely you are sharing the workgroup file on the server,
and this has to be opened/closed. By forcing a connection open at all times,
then this delay is eliminated. Give this trick a try...
 
Unfortunately this suggestion made no difference in the
performance. Any other suggestions?
 
fred said:
Unfortunately this suggestion made no difference in the
performance. Any other suggestions?
Click to expand...

ok, I will assume you did the above correctly\ (you can test the above by
simply opening a table, and minimizing it..and then try your forms/code).

Also, to be clear here..you are saying that BEFORE you secured this
database, it ran fine on the lan?

So, on your setup, each user has their own FE, each front end is a mde, and
the workgroup file is on the server with the back end...right?

You can certainly go through the check list here of performance problems,
but none of the
entries in the following list mention that setting security on a database is
a known problem.

http://www.granite.ab.ca/access/performancefaq.htm

You can certainly try some things from this list. If you find the reason for
this
performance drop, I hope you can share it with us, and Tony will include it
in his
above list of "got ya" things for look for.
 
So far I haven't made any progress on this problem. The
front end is not an MDE yet, but I am the only user until
I can get this straightenend out.

There is a clue that I don't know how to interpret:
When the form is taking a long time to load, the
Windows Task Manager" shows the application as "Not
Responding". Eventually, when the form loads, the
application returns to the "Running" status.
 
Back
Top