473,320 Members | 2,088 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

My client's Access 2002 db crashes. Why???

Hi there,
Hope you guys can help me out.
For one of my clients I have created an Access 2002 db. It used to be
under Access97, but I have converted it to Access 2002, without any
problems.
My client works with this db in a multi-user environment.
(Another client of mine works with this db in a multi-user environment
as well, but under Access97. Done so for years now without problems)

The first client is experiencing frequent Access crashes. An error
appears claiming taht the application has performed an illegal
operation and needs to shut down. Then they ask whether the client
wants to send this error report to Microsoft. And after that the db is
really screwed up. (they have a good backup of the db, so they install
that again). What I can't figure out is why the db crashes and
especially so frequently (at least once a day).
This is the info I have so for. They work with Managed workplace. And
they recently told me that their network sometimes has a time-out of a
few seconds.
Maybe that's the culprit?
Furthermore, the crash usually occurs on a workstation which has been
idle for a time. Which I find even more strange.

Does anybody have any suggestions how I can find out what is happening
and even better, how I can go around solving this problem?

Thanks
Esmee
Nov 12 '05 #1
4 2076
"Esmee" <g.********@inspektor.nl> wrote in message
news:2e**************************@posting.google.c om...
Hi there,
Hope you guys can help me out.
For one of my clients I have created an Access 2002 db. It used to be
under Access97, but I have converted it to Access 2002, without any
problems.
My client works with this db in a multi-user environment.
(Another client of mine works with this db in a multi-user environment
as well, but under Access97. Done so for years now without problems)

The first client is experiencing frequent Access crashes. An error
appears claiming taht the application has performed an illegal
operation and needs to shut down. Then they ask whether the client
wants to send this error report to Microsoft. And after that the db is
really screwed up. (they have a good backup of the db, so they install
that again). What I can't figure out is why the db crashes and
especially so frequently (at least once a day).
This is the info I have so for. They work with Managed workplace. And
they recently told me that their network sometimes has a time-out of a
few seconds.
Maybe that's the culprit?
Furthermore, the crash usually occurs on a workstation which has been
idle for a time. Which I find even more strange.

Does anybody have any suggestions how I can find out what is happening
and even better, how I can go around solving this problem?

Thanks
Esmee

Is the application split front and back end? It certainly should be.

Is user-level security involved? If not (or if it wouldn't take too long to
reset) you could create a brand new blank database using Access XP (possibly
on site) and import all objects into the new one. Make sure it compiles.

I have found stability issues when swapping db's between machines with
different versions, which following the above advice has sorted out
entirely. An alternative is to start the database with the /DECOMPILE
switch and then later recompile on the XP machine.

Fletcher


Nov 12 '05 #2

Thanks for your reply Fletcher.
Of course the application is split front end and back end.
And I have already once created a completely blank database and imported
all objects into the new one.
And I have decompiled the application using Access XP.
But the problem still persists.
Thanks for your suggestions. Any more ideas?
That would be great
Esmee
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3
"Esmee Waller" <g.********@inspektor.nl> wrote in message
news:40*********************@news.frii.net...

Thanks for your reply Fletcher.
Of course the application is split front end and back end.
And I have already once created a completely blank database and imported
all objects into the new one.
And I have decompiled the application using Access XP.
But the problem still persists.
Thanks for your suggestions. Any more ideas?
That would be great
Esmee

You could certainly look here for a start:
http://www.granite.ab.ca/access/corruptmdbs.htm

Fletcher
Nov 12 '05 #4
Esmee Waller <g.********@inspektor.nl> wrote in
news:40*********************@news.frii.net:
Of course the application is split front end and back end.
And I have already once created a completely blank database and
imported all objects into the new one.
And I have decompiled the application using Access XP.
But the problem still persists.
Thanks for your suggestions. Any more ideas?


If there are network timeout issues, that's likely to bollix up
Access, as it is completely unforgiving of that kind of thing.

Are user getting the "disk or network error" message? That's what
I'd expect if the timeout were the source of the problem.

It also seems strange to me that the data would get corrupted by a
crash like that. Perhaps memo fields are getting corrupted? If so,
you should strongly consider going to unbound memo fields. I explain
how to do that near the end of this post:

http://groups.google.com/groups?selm...entonbwaynetin
vali%4024.168.128.78

But my guess from your remark that you just restore the corrupted
MDB from a backup is that you are getting corruption in the front
end, not the back end, and that would likely be because you're
sharing it.

The effort of splitting is not worth a bucket of warm spit if you
still share the front end.

If that's not the case, then I can't think of anything else without
further information.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Thomas Baier | last post by:
Hi there, I'v got a little program generating coincidental lists. It crashes with memory access failure, but not always at the same time. If I start the programm using valgrind it always...
0
by: Damon Heron | last post by:
This is repeatable: I recently upgraded to 2002 from 2000. When I start Access 2002, and open my 2000 mdb file, it works normally. However, if I open my mdb file by clicking on it directly, it...
0
by: H. Peter Lienhardt | last post by:
One of our app written in Access 2002 crashes frequently under Windows 98 - there is no such problem under NT, W2k or Windows XP. The problem starts with the Windows message 'There are not...
1
by: Alan Brasel | last post by:
I have an Access database that I have been using for over a year. My company just replaced my computer with a "New and Improved" computer, and they also installed Access 2002 ( I was using 2000). ...
0
by: Malcolm Cook | last post by:
I've discovered: Using "File > Print Preview" in a form's datasheet view with a server Filter crashes access after previewing... ....that is, unless ServerFilterByForm has been turned off...
1
by: Mike Ridley | last post by:
I am trying to create a new query using 3 linked tables. As soon as I add the third table to the design grid Access crashes. I have looked in the newsgroup and find that there have been problems...
2
by: Bruce Dodds | last post by:
I will be doing an app for a nonprofit. It would be useful for them to have a good entry-level book on Access so that they don't have to pay someone to design all their queries and reports. I'm not...
2
by: Ray | last post by:
Stop me if you've heard this, but I am running Access 2002 and all of a sudden, if I design a particular form (it's been working fine for ages), Access crashes rather than open it in design view. ...
47
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.