vb6 Access database - too many user

[cymichaelip]

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

[Tom van Stiphout]

On 24 Mar 2007 20:22:07 -0700, cy*********@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.

>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

[cymichaelip]

On Mar 25, 12:26 am, Tom van Stiphout <[e-mail]:

On 24 Mar 2007 20:22:07 -0700, [e-mail] 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.

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

[David W. Fenton]

cy*********@gmail.com wrote in
news:11**********************@n76g2000hsh.googlegr oups.com:

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?

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/

[Tom van Stiphout]

On 24 Mar 2007 21:34:55 -0700, cy*********@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>>

>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