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.

 

[Pat Hartman]

It means what it says, there are too many users. Access is limited to 255 concurrent users. MSDN is limited to 4. SQL Server and others are limited to the number of licenses you own.

 

[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?

 

[Pat Hartman]

The .ldb file should be created when the first user opens the .mdb file and deleted when the last user closes it. If the .ldb file is not being deleted when the last user closes the .mdb, it is usually an issue with permissions to the shared network folder. Each user must have permission to create new files in the folder that contains the Access .mdb and also must be able to delete files in that same folder in order for the .ldb to function properly.

 

[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