MS Access Connection problem

[mira]

In a VB6 application using MS Access 2000 as a database, the following behaviour occurs. After performing any action query, for example a SELECT INTO or an INSERT statement, there seems to be a steady flow of data to and from the computer which ends only at the termination of the program. The network icon shows constant activity and packages seem to be sent and received.

Trying to trace the problem I made a simple test program that connects to the database and performs a simple INSERT statement. I run the test program from two machines in the network, connecting to a copy of the database. The moment the second user performed the INSERT statement the same behaviour occured. Testing other company applications using MS Access as a database the same thing was also noted.

It is very critical to me to find the reason why this happens. If anyone can help please do!

[hspc]

Seems a network problem not a programmatic problem
but any way Please send more detailed info like :
Connection string : (ODBC or OLEDB)
How do you make the insertion (using Command / Connection)
number of records and users in the system
locking type you use....
this info MAY help us helping you

[mira]

I forgot to mention that I am connecting to the database using RDO. The connection is done the following way:
with cn
.Connect = "DSN=dsnMyDB"
.CursorDriver = rdUseIfNeeded
.EstablishConnection rdDriverCompleteRequired
end with
The DSN has the default parameters except for a buffersize of 8192.
The insertion is done this way: cn.Execute sSQL

There are about 10 users using constantly the application in a total of about 25 users. The number of records is 30.000 the most.

In case this is network problem what should I look for?