I use Vb6 to develop a application and Access 97 database.
I use DAO 3.5 dynaset method (Dynaset, Snapshot Method) open database.
This application is used by 15 person consurrently.
Sometime/Ocassionally the application will automatically close
during accessing database. Why After the application suddenly
close and I rerun the application and operate as before,
the problem doesn't happen again.
That's a reason I can't troubleshoot/Solve the problem using VB6
enviroment, it wasn't coding problem.

Wish that someone could share their experience with me on this problem.


My Questions
1. Why the application will automatically close during accessing
the database?

2. Any bug in Ms Access that can't support concurrent
users enviroment?