RE: Access Startup Speed Degradation

Do you reboot the computer(s) frequently? Back in the day, opening and
closing the same app over and over ate up memory. A reboot regained the lost
memory. Check Task Manager to make sure that you aren't low on memory when
things slow down.

Speaking of memory leaks and "back in the day", make sure that you are
closing any recordsets opened in code with something like below:
rs.Close
Set rs = Nothing
db.Close
Set db = Nothing

Also while in Task Manager make sure that there aren't multiple versions of
the same app running. It might not be closing cleanly.

Do all users of the database must have at least read, write, and modify
privileges to the folder holding the database file. Not just the database
..mdb file, but the entire folder.

Try turning off the virus checker for testing purposes. If things speed up,
exclude scanning of .md* files.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Ray" wrote:

Access 2000
WinXP-sp2
3ghz processor
Ample Drive Space
1 gig ram

After the inital install - Access will start in 3-5 seconds....
A specific application is started, run, and closed multiple times by
multiple people each day as part of a production environment on a
specific machine (Yes - there are multiple users - but not
simultaneous multi user and Access is installed locally on this
machine.)

After a couple of months, the application was noticeably slower -
taking 20 seconds or longer to start. The database was repaired and
compacted, the machine defragged, most of the normal stuff you would
do for a slow application/machine. It was then discovered that if you
opened Access alone (no database) it still took 20+ seconds to open.
So we uninstalled and reinstalled Access. No Change!

We discovered that any other user (using a different profile on the
same machine) would run fast. So we backed up the desktop and
documents folders, deleted the profile, recreated it, and restored
the desktop items and documents. Voila! Back to 3 seconds to start.

We have been having to do this roughly every 2-3 months to keep
startup time quick. Does anyone have a clue what would cause this?

Thanks in advance for any information, and a second thanks for
bothering to read all of this....

Ray

Not wanting to cross post everywhere - I am putting this in
GettingStarted and SetupConfig. If you think there might be another
group that would be better suited to answer this type of question -
I'd appreciate a heads up...

Thanks again!

.

Relevant Pages

  • Re: whats better way to store a million keys in mem?
    ... looking at static var in memory. ... servers, if you tend to have a million users. ... and if you use multiple ... so therefore you are looking at some sort of database or shared disk storage. ...
    (comp.lang.java.programmer)
  • Re: whats better way to store a million keys in mem?
    ... looking at static var in memory. ... servers, if you tend to have a million users. ... and if you use multiple ... so therefore you are looking at some sort of database or shared disk storage. ...
    (comp.lang.java.programmer)
  • Re: dataset Performence Issue
    ... Microsoft that a DataSet is okay to abuse as a DataBase. ... Managed Code can never be as fast and as optimized ... very good for 90% of the situations i.e. normal memory usage, ... Merge/GetChanges - and oh lets not forget keeping your disconnected cache ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cpp Considered Harmful
    ... was received would push it on the queue. ... It's main advantages are the multiple use ... research and experience into concurrency and system design in order to ... Threads share memory, the problem is they share all memory (well not ...
    (comp.lang.cpp)
  • Re: Verbose functional languages?
    ... Speaking of multiple cores: when I look at what's Intel talking about, ... Even memory allocation would create all kinds of mutual wait ... I'm less convinced about general use of semi-space moving collectors ...
    (comp.lang.functional)
Loading