Multi-user connection

A

Alan T

I know MS Access database file is mult-user.
Any idea how many users it supports in maximum?

I will develope an application which accesses the MS Access 2003 database
file only (the pc has only the database file, .mdb, no Access software
installed), is there any limit on number of connections?
 
D

david

255 connections.

First you have to ask how many connections your server can support :~)
Windows workstations can only support maybe 10 connections.

You can get more than 255 if you force the file into read-only mode.
The 255 connection limit is only because Access seperatly tracks the
user locks. If you force it into read-only mode, it doesn't need the
user-names

(david)
..
 
Top