Connecting Tech Pros Worldwide Help | Site Map

vb6 Access database - too many user

cymichaelip@gmail.com
Guest
 
Posts: n/a
#1: Mar 25 '07
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
Guest
 
Posts: n/a
#2: Mar 25 '07

re: vb6 Access database - too many user


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.

Quote:
>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@gmail.com
Guest
 
Posts: n/a
#3: Mar 25 '07

re: vb6 Access database - too many user


On Mar 25, 12:26 am, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
Quote:
On 24 Mar 2007 20:22:07 -0700, cymichae...@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.
>
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
Guest
 
Posts: n/a
#4: Mar 25 '07

re: vb6 Access database - too many user


cymichaelip@gmail.com wrote in
news:1174797295.311955.297850@n76g2000hsh.googlegr oups.com:
Quote:
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
Guest
 
Posts: n/a
#5: Mar 25 '07

re: vb6 Access database - too many user


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>>
Quote:
>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
Closed Thread