DAO 3.5 dynaset method (Dynaset, Snapshot Method) open database

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?

mongyee,

The bug would most likely be in the way you operate on the database. Look here for more info.

Your code would need to be looked at to determine the real issue. Post some code.