DB quits on record/form change

[Pendragon]

Access03/WinXP

I have a client on a multi-user FE/BE environment. The following occurs on
only two of the dozen computers; both computers are current in all MS Updates.

In this database, Companies and Individuals are split into two tables and
Individuals are linked to Companies via CompanyID. In the form for
companies, I employ a combo box to list the employees associated with the
selected company. On selection of an employee, the form for Individuals is
opened and the recordset is filtered to the selected individual.

This process has worked for years for many clients. For the problem client,
who has been using this application for about a year, the two problem
computers only encountered a problem within the last two months (and didn't
tell me about it as they thought it was user error).

The problem is that after selecting an individual from the Companies form,
the Individuals form briefly flashes and then the entire Access application
quits.

All references are set (as they are for the numerous other clients/users),
the code has been compiled successfully and the database compacted and
repaired. I even manually copied the front end application from one computer
and loaded onto a problem computer, and it still crashed. I have noticed
that the application ldb file is not deleted after the application crashes;
normally the ldb is closed and disappears when a proper exit is done.

Any ideas?

Thanks!

 

[Roger Carlson]

Personally, I'd check on network problems, especially if they are on the
same segment. Access is an excellent "canary" for network problems as it
will be the first to "die" when something flaky is going on.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L