acces 2000? hvor mange forbindelser

Umiddelbart kan jeg ikke se nogen begrænsning.

Access er ikke en server. D.v.s. at adgang til en Access
database sker som fil-adgang.

Så jeg vil tror, at det udelukkende er Windows og
IIS der sætter brgrænsningen.

koldstar this question has been up MANY times.  Access 97, 2000 +XP has a theoretical maximum of 255 users but normally this will be less. There are a few things you need to concider  when using Access. When you read data from Access you should close (free) the connection  as soon as you are finished with it. If you do this then the chances of you haveing say 20 connections open at one time are VERY slim. Just as an example, there are "only" 148 users on line in eksperten, but not all of these will be accessing the dB (read/write).
There are many web sites which use Access as the database without great problems. But IF yopu expect 1000's of simultaneous users then go for either MySQL or MS SQL.

Where do the 255 limit come from ? (just curious)

Bill :o) (MS)

Ofcourse.

But how is the limit technically implemented.

It is easy to understand how such a limit exist in a
database server, where a server process get
everything.

But Access is a file database. What does keep track
of how many connections there are ?

Access implements its own security system which by default is ON, although you dont see it. You will also have noticed that when the db is opened a LDB file gets created. Well I could imagine that this COULD be used for this although I must admit I am not sure.

koldstar have you got your answer?

koldstar how about clsoing this question!

Helllloooo....

hello.
Sorry i've forgot all about this question.

tak :o)
and the same applies to your new question :o)