Access causing other programs to CRASH

[Bart]

Has anyone heard of a problem with Access that would cause
other programs to CRASH? We have been using a 8MB MDE (21
MB MDB) Access 2000 program with a few dozen users in it
at any given time. It uses alot of VBA mostly with
recordsets. They open it through a shared network drive.
For several months it has worked correctly and the last
version I gave them worked fine for a week and then
suddenly my users are experiencing slow response times
with opening, closing and printing. Several other
programs (WORD, EXCEL, POWERPOINT) are locking up. When
they try to reopen it, they receive a message that
says "The Microsoft Jet database engine could not find the
object 'Databases'. Make sure the object exists and that
you spell its name and path correctly." Our PCS
department thinks that it is the Access database but I
experience the same problem going back to earlier versions
that had no problem. This also seems to affect terminals
that do not even se the database. I have compiled the
database and ran the compact and repair. There doesn't
appear to be any problems with the code. I made a new
MDE. The program works fine when it is on the desktop but
it locks up when multiple users access it on the network.
I have also placed the MDB version in the shared drive but
when it locks up it doesn't hit any debug errors. It just
freezes and sometimes virus scan pops up. I think it has
to be an issue with the server but I would like the advise
of other developers.

 

[Anne Troy]

Make sure their temp folders are cleaned up, then do a fresh restart. To
empty the temp folders: Start-Run, type "%temp%" (no quotes) and hit enter.
Delete all the stuff in there.
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->

 

[jim jackle]

I have one for you. My Outlook and Access occasionally
flake out together on our XPpro sysytem. Sometimes my
memo fields lock up. I then have to close down Access and
it doesn't completely close down and I have to re-boot.
When I try to log off, I close down Outlook. It looks
like it's shut down. Then i shut down and it says outlook
is still open, do I want to shut down, AND IT WON'T!

 

[Adrian Jansen]

Sounds like a case of code leaving created objects or recordsets open, when
they should be closed and set to Nothing at the end of each call. Fun to
trace in a big project.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control