vb6 Access database - too many user

Hi

I have a VB 6 application, use MS Access and OS is XP home. Another 3
computers which using XP home connect to it. At the beginning the
application running is fine, but few hours later a error message come
out "Too many active users". Any body know why this error message come
out and how to solve it. Below is more information

Computer A - store MS Access database and OS is XP home, using VB
application form A refresh every 5 sec.
Computer B - Using computer A database and OS is XP home, using VB
application form B refresh every 5 sec.
Computer C - Using computer A database and OS is XP home, using VB
application form C refresh every 5 sec.
Computer D - Using computer A database and OS is XP home, using VB
application form D refresh every 3 sec.

I like to know the problem is the Network? or the Database? or the
Application? or OS?

Please help and thanks in advance.
Michael

On 24 Mar 2007 20:22:07 -0700, cymichaelip@gmail.com wrote:

The application.
Certainly 3 is not too many, but if your app is allocating resources
and not releasing them, over time you'll run out of them.

-Tom.

On Mar 25, 12:26 am, Tom van Stiphout <no.spam.tom7...@cox.netwrote:Thanks Tom

you said " allocating resources and not releasing them", do you means
I need to close the recordset? I have close the recordset and database
after use.

rs.close
set rs=nothing
db.close
set db=nothing

But on the .ldb file, I saw computer 1, 2, 3, 4 not only show one
time, its show many times. do you know why?

Michael

cymichaelip@gmail.com wrote in
news:1174797295.311955.297850@n76g2000hsh.googlegr oups.com:
You must be opening multiple connections. Access does this silently
sometimes, but I've never seen more than two at a time from any
workstation. I would think that you'd have to manage all of this
manually when using VB, as I assume Access itself manages
connections because it understands Jet by definition.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

On 24 Mar 2007 21:34:55 -0700, cymichaelip@gmail.com wrote:

That's where your debugging needs to start. I bet you early on you
only see 4 users, and gradually that number increases.
Find the code that does that, and fix it.

-Tom.

<clip>>