Microsoft Access Crashes

[Guest]

I have an Access application that crashes Access "Microsoft Office Access has
encountered a problem and needs to close" when a particular line of code is
run. The line of code is simply 'DoCmd.RunCommand acCmdRefresh'. This error
happens not 100% of the time but about 2/3rds of the time. I use this
command to refresh the data being viewed on a form containing multiple
sub-forms.

Suggestions and/or Solutions??

Database is split (front end is local, and back end is on a server), in a
multiuser enviroment (Currently less than 10 concurrent users). Occurs
whether or not the underlying system is NT4 or XP-Pro, Access 2000 or 2003
(table structure is set to 2000)

Thanks fot your support

 

[Arvin Meyer [MVP]]

There is a chance of a bad or failing video card on 1 machine. It may have
corrupted the local copy used to develop the others. Do a repair and compact
on a machine that's not used for development, or better yet decompile then
repair and compact.

http://www.mvps.org/access/bugs/bugs0008.htm

I like to compile my databases with each of the versions used to run them. I
have had corrupt forms which only worked properly when decompiled then
recompiled on the system used to run them.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Guest]

Sounds like corruption.
Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

 

[Guest]

I have tried decompiling/recompiling(I did find some orphan code). I tried
removing all code and replacing. About the only thing that has changed is
the failure is at 100% now.

I appreceate all of your help so far... any other suggestions ??