Access -- connection number

[Tracer]

Hi!

How many connections are possible to use with MS ACCESS database? As i
heard, 64 connections per proccess, and 255 client connections. IS THIS

TRUE?

Does a number of connections depends on a operating system? If so, does

that mean that if i place a MS ACCESS database to a WinXP operating
system that it will only support 10 connections (winxp limit)
regardless MS ACCESS limit of 255 client connections?

Thanks!

 

[Brendan Reynolds]

The restrictions on database connections and network connections are not
directly related to one another. By which I mean that you could have more
than 10 database connections to an MDB on an XP PC if some of those
connections were local connections. For example you might have multiple
programs running locally on the XP PC connecting to the database. But you
could not have more than 10 network users simultaneously connecting to the
database. The restriction then would not be the number of database
connections, but the number of network connections.

 

[Dave Flowers]

Hi,

It has been my experience that if you have more than 5 or 6 connections to
an Access file that performance takes a real hit. At 10 you might as well
forget about getting anything done. In this case the mdb file was 60 MB in
size. We converted our customer over to a SQL 2000 database and eliminated
all performance problems. We were using a VB 6 app with OLE DB to access the
mdb file on the server. It was fairly easy to edit the VB code for the
conversion.

Dave

 

[Tracer]

Hm... About SQL 2000.. I have downloaded MSDE (A) release and i am
interested how many connections does he support? I heard 10, but some
people say 50. Which is true?

Also, is SQL Server file-shared based database, and so, limited to ten
connections under Winxp Pro? Thanks.

Zeljko Kovacevic