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

=?Utf-8?B?YW93aQ==?= <(E-Mail Removed)> wrote in
news:1E036282-AC71-49AF-A4FE-(E-Mail Removed):

> 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! |
*******************************************

//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.





"Gregory A. Beamer" <(E-Mail Removed)> wrote in message
news:Xns9C33A31E4807Cgbworld@207.46.248.16...
> =?Utf-8?B?YW93aQ==?= <(E-Mail Removed)> wrote in
> news:1E036282-AC71-49AF-A4FE-(E-Mail Removed):
>
>> 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! |
> *******************************************

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

"Gregory A. Beamer" wrote:

> =?Utf-8?B?YW93aQ==?= <(E-Mail Removed)> wrote in
> news:1E036282-AC71-49AF-A4FE-(E-Mail Removed):
>
> > 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! |
> *******************************************
>

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!

"sloan" wrote:

> //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.
>
>
>
>
>
> "Gregory A. Beamer" <(E-Mail Removed)> wrote in message
> news:Xns9C33A31E4807Cgbworld@207.46.248.16...
> > =?Utf-8?B?YW93aQ==?= <(E-Mail Removed)> wrote in
> > news:1E036282-AC71-49AF-A4FE-(E-Mail Removed):
> >
> >> 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! |
> > *******************************************
>
>
>

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(??).





"aowi" <(E-Mail Removed)> wrote in message
news:E879CA9D-D970-42C5-A3ED-(E-Mail Removed)...
>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!
>
> "sloan" wrote:
>
>> //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.
>>
>>
>>
>>
>>
>> "Gregory A. Beamer" <(E-Mail Removed)> wrote in message
>> news:Xns9C33A31E4807Cgbworld@207.46.248.16...
>> > =?Utf-8?B?YW93aQ==?= <(E-Mail Removed)> wrote in
>> > news:1E036282-AC71-49AF-A4FE-(E-Mail Removed):
>> >
>> >> 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" <(E-Mail Removed)> wrote in
news:(E-Mail Removed):

> //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! |
*******************************************

=?Utf-8?B?YW93aQ==?= <(E-Mail Removed)> wrote in
news:5F186573-8B03-4CCF-A32A-(E-Mail Removed):

> 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! |
*******************************************