Too Many Active Users

[tsh21]

Anyone experience this error message before? the full error message are as follow :
[Microsoft ODBC] Too many active user

Why will this occur? Is it due the .ldb file size? Information: Using XP machine and MS 2000 server.

Please help.

 

[tsh21]

I suspect because of that too. But One thing funny is I am using Ms Access database and the .ldb file is created once it is accessed. But this ldb file keeps on growing and once it is more that 16KB, it will prompt this message. I have tried deleting some of the records inside this file, hence the size reduced. Then everything is ok.

why is this?

 

[tsh21]

I have give all users read, write, modify, delete permissions to the folder, hopefully this will solve my problem.

Thanks a lot

 

[tsh21]

Problem still persist

I have given all permission to all users to the database, it seems doesnt work too.

Everytime I have to restart the server, then only it will be ok for the day.

What else can cause this problem?

 

[tsh21]

Anyone please help on my problem. Anyone have any idea to reduce the size of *.ldb file manually. As I suspect the creation of ldb file and does not remove by itself causes my machine to prompt "Too many active user" message.

 

[WayneRyan]

tsh,

Read Pat's last post again. You and your users must not have
the appropriate access to the directory where the database
and .ldb file are.

Can you manually delete the .ldb file? It you can't, then you
and your users won't be able to do it through Access.

Wayne

 

[tsh21]

At times I can delete the ldb manually. At times I can't. I have tried testing on few PC. And the ldb able to create and delete by itself. But when all users are using it, I really does not know how the ldb does not remove by itself at times.

 

[WayneRyan]

tsh,

What you need to do is ensure that the users (and you) can
delete the .ldb file. Normally, Access "wants" to do this when
all users are through with the db.

Wayne

 

[yippie_ky_yay]

Hey tsh,

are you by chance using using something else other than Access as the front-end?

I had a similar problem where I was using Access as a backend for a web application and I couldn't delete or modify the ldb file until after 10 minutes (which is what the set timeout of the ODBC was). After the 10 minutes was up - it would delete itself automatically.

So if you're opening connections manually (through code), try making sure that they're set to "Nothing" at the end of your routines.

Let us know!

-Sean