ACCESS database connection error:DB-0053 The maximum number user r

[aowi]

Hi,

I am developing a windows application using VB.NET. The program connects to
a demo database in MS Access. Before I could log in fine, but today, I can
not log in to database anymore, and was given a message : DB-0053, The
maximum number users has been reached.

Although I re-install the database, I got same error.

Does anyone has an idea what causes this? Is it because the database
connection was not closed properly before and memory leak too much?

Any help is appreciated!

Thanks!

Aowi

 

[Gregory A. Beamer]

Hi,

I am developing a windows application using VB.NET. The program
connects to a demo database in MS Access. Before I could log in fine,
but today, I can not log in to database anymore, and was given a
message : DB-0053, The maximum number users has been reached.

Although I re-install the database, I got same error.

Does anyone has an idea what causes this? Is it because the database
connection was not closed properly before and memory leak too much?

Possibly. It could also be because the database is not set up for multi-
user and somebody has opened the physical file.


--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************

 

[sloan]

//Quote//It could also be because the database is not set up for multi-

user and somebody has opened the physical file.//End Quote//

In addition to the above: open up the [myfile].ldb file in notepad for some
hints. LDB extension for clarity.

 

[aowi]

Thank you! But, do you know, how to set up the multi-user access in the case
I don't have MS ACCESS desktop on the server?

Aowi

 

[aowi]

I opened the ldb file using note pad, it shows something like:
ä•„äµ–å‘…ã1†††††††††††æ‘業n†††††††††††††, non-readable at all...

So how to get any hints from here? Thank you!

//Quote//It could also be because the database is not set up for multi-

user and somebody has opened the physical file.//End Quote//

In addition to the above: open up the [myfile].ldb file in notepad for some
hints. LDB extension for clarity.

Possibly. It could also be because the database is not set up for multi-
user and somebody has opened the physical file.


--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************

 

[sloan]

Back in the day you could "interpret" them via notepad.

Here is some code, but they are dated to Access97. I don't know which
version you have.... You'll have to search to see if there are new
equivalents of the below KB's.

http://support.microsoft.com/kb/186304
http://support.microsoft.com/kb/166938

I don't know what they do now, I haven't coded a JET database since
1998(??).

I opened the ldb file using note pad, it shows something like:
????1?????????????n?????????????, non-readable at all...

So how to get any hints from here? Thank you!

//Quote//It could also be because the database is not set up for multi-

user and somebody has opened the physical file.//End Quote//

In addition to the above: open up the [myfile].ldb file in notepad for
some
hints. LDB extension for clarity.

Hi,

I am developing a windows application using VB.NET. The program
connects to a demo database in MS Access. Before I could log in fine,
but today, I can not log in to database anymore, and was given a
message : DB-0053, The maximum number users has been reached.

Although I re-install the database, I got same error.

Does anyone has an idea what causes this? Is it because the database
connection was not closed properly before and memory leak too much?


Possibly. It could also be because the database is not set up for
multi-
user and somebody has opened the physical file.


--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************

 

[Gregory A. Beamer]

//Quote//It could also be because the database is not set up for
multi-

user and somebody has opened the physical file.//End Quote//

In addition to the above: open up the [myfile].ldb file in notepad
for some hints. LDB extension for clarity.

Do you mean you opened up the lock file? If so, you have potentially
locked the database. Notepad should not lock text files, but I am not
sure what it does to Access lock files.

The best bet, with access, is to be exclusive for the web and not touch
the files. If you must touch them, make sure the database is multi-user.
And, you are better to actuallly link a second Access database to the
Access file and examine thorugh the links, as this is less likely to
lock things than using the actual file.

My personal choice would be to move to some version of a real relational
database, like SQL (Express or full), Oracle, MySQL, etc.


--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************

 

[Gregory A. Beamer]

Thank you! But, do you know, how to set up the multi-user access in
the case I don't have MS ACCESS desktop on the server?

It should be as simple as opening the Tools >> Options and then making sure
the open mode is shared and the record locking is no locks. With newer
versions of Access, this is the default, but if the database was created in
an older version this might not be true.

I am not the best expert on Access, but I have had to play with it a lot
lately. ;-)


--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************