MS Access Multiuser - increase MS Access connection limit

Author

increase MS Access connection limit

John Lau

2005-09-20, 8:24 pm

Hello,

Is it possible to increase the MS Access connection limit from 64 to a
higher number? How?

Thanks,
John

david epsom dot com dot au

2005-09-21, 7:24 am

MS Access doesn't have a connection limit of 64.

Access is a "file share" database system.

It uses the native database functions of the
Windows file system.

The limit to the number of read connections is
the limit of your file server, if it has a limit.

I don't know what limits are for Windows Servers
now, or if they have any limits at all. You can
ask in a Windows Server group.

For read/write connections, Access has a connection
limit of 255. If you need more users, you have to
close connections or share connections. As you would
if you were using any other database system.

This r/w limit is enforced by the record locking
system. If you only read the records, you don't
need to lock them, so there is no limit to read
connections.

A common method of sharing connections is to use
a Web Server. A typical web server might have
10 database connections, and share them between
all the Internet users.

Microsoft benchmarked Access 97 with 32 users,
which gives you some idea about the kind of load
they thought might be reasonable on a file server
at that time, but those users were benchmarking
programs, so they were heavy users.

(david)

"John Lau" <johnlau@olc.ubc.ca> wrote in message
news:%23GWDLHivFHA.1988@TK2MSFTNGP10.phx.gbl...
> Hello,
>
> Is it possible to increase the MS Access connection limit from 64 to a
> higher number? How?
>
> Thanks,
> John
>

John Lau

2005-09-22, 1:24 pm

Hi David,

Thanks for your reply. The 64 connection limit is per process. I wrote a
program that just opens connections and keep them open. The program bombed
after 64 connections. This was on an XP and a 2003 server. I could run
multiple copies of my program, so you're right that 64 is not a server
limit.

Interestingly, when the program bombed, it released all of its connections.
I had to stop the program before it bombed, and then running it multiple
times, I found the 2003 server limit was 310 connections. After that I got
a "too many active users" error.

I did not read data, just open connections, and I got the error.

Sounds like this limit cannot be changed.

Cheers,
John

"david epsom dot com dot au" < david@epsomdotcomdot
au> wrote in message
news:%2364b8eovFHA.1392@tk2msftngp13.phx.gbl...
> MS Access doesn't have a connection limit of 64.
>
> Access is a "file share" database system.
>
> It uses the native database functions of the
> Windows file system.
>
> The limit to the number of read connections is
> the limit of your file server, if it has a limit.
>
> I don't know what limits are for Windows Servers
> now, or if they have any limits at all. You can
> ask in a Windows Server group.
>
> For read/write connections, Access has a connection
> limit of 255. If you need more users, you have to
> close connections or share connections. As you would
> if you were using any other database system.
>
> This r/w limit is enforced by the record locking
> system. If you only read the records, you don't
> need to lock them, so there is no limit to read
> connections.
>
> A common method of sharing connections is to use
> a Web Server. A typical web server might have
> 10 database connections, and share them between
> all the Internet users.
>
> Microsoft benchmarked Access 97 with 32 users,
> which gives you some idea about the kind of load
> they thought might be reasonable on a file server
> at that time, but those users were benchmarking
> programs, so they were heavy users.
>
> (david)
>
>
>
>
>
> "John Lau" <johnlau@olc.ubc.ca> wrote in message
> news:%23GWDLHivFHA.1988@TK2MSFTNGP10.phx.gbl...
>
>

Sponsored Links