I have an application with 3 separate databases. When accessing the data through the main form for one of these, searches can take 10 minutes and lockups happen frequently. I guess I need to put in explicit locks, but I'm not sure where PLUS none of the tables are editable in the form. Why would this database be prone to crashing when the others are not? To top it off, only 2 tables are involved in this database and there are 10-12 open in the other situations. The users are not happy.