Access 2003 crashes

S

Seth

My company employs a SQL back end with an Access 2003 front end.
Recently, two computers on our network have been having their Access
crash multiple (up to 10) times per work day. They can restart, but
this is a major annoyance. These two computers seem to be the only
ones who are having this problem. They belong to our company
secretaries, and the secretaries generally leave the Access open for
long periods of time. Often, the crashes occur when Access is
minimized or not being used. The error log lists event ID 1000,
faulting application: MSAccess.exe, faulting module unknown, address
all 0s. I'm at the end of my rope here. Any help would be
appreciated.
Seth
 
A

Albert D. Kallal

I assume you done the standard compact and repair.

I assume that each user has their OWN copy of the front end.
(you do NOT allow multiple users in the front end..right?)

I assume that each user gets a mde database...right?

Given that you have the above standard and good practices in place, then I
would try and install the sp1 update for office.
(if you don't have the above standard setups, then you need
to fix that first)

The office sp1 update does have fixes based on the crash test reporting when
you hit send.
(you have been hitting the send error report to get YOUR stuff included in
this
office update and bugs fixes...right!!).

Generally, my a2003 stuff have been very stable.

However, I did have ONE database that did frequently crash. Since installing
sp1 last week, I have not experienced ONE
ms-access fault.

I would say now my access is very solid.....
 
S

Seth

Albert,
Yes, I have tried the compact and repair, each user has his/her own
front end, and they're using an mde. Thought I had installed SP1, but
it turns out I was mistaken. I'll give it a try. Thanks a lot,
Seth
 
O

One Missico

If you are still having a problem, check for broken or missing references on
the client computer.

--
Let the group know if this has been helpful.

Thank you,
Anthony Missico, Jr.
Missico Information Systems
[email protected]
949-859-1741
 
S

Seth

Hey everyone,
I installed the service pack, but to no avail. Also, I checked
the references, and everything seems to be in order there. Pretty
stumped at the moment. Anybody have any other ideas? Thanks in
advance,
Seth
 
A

Anthony Missico, Jr.

I suggest you find out what is different between the working and non-working
machines.

Without specifics, I suspect:

1) version differences in the libraries. Compare version information for
everything. Make sure you have correct versions. Just because you install
something, doesn't mean it gets installed. Check for File Protection events
to see if a file is not being installed. (Remember, you can add the "File
Version" column to Windows Explorer in WinXP.)

2) code. You are doing something that is causing the problem, which
manifests on these two machines because of the running time. See if you can
get a working machine to fail. Is _your_code doing anything in the
background? If so, comment it out and see if problem occurs. Try commenting
out large blocks of code for specific sub-systems.

--
--
Let the group know if this has been helpful.

Thank you,
Anthony Missico, Jr.
Missico Information Systems
support_@missico_com_
949-859-1741
 
Top