Re: Number of concurrent users

On May 5, 11:41 pm, "Paul Shapiro" <p...@xxxxxxxxxxxxxxxxxxxxxxx>
wrote:
Access doesn't limit the open connections, just the users. But if you're
hosting the data on a workstation OS, I think recent OS versions are all
limited to 10 connections. Since it looks like you're planning more than 10
users, you should be sure you can host the data file on a server OS. And to
emphasize what John already said, you DEFINITELY want to split your
application into a front-end db and back-end db. Only the backend (just the
tables and relationships) goes on the server. Each user should be running a
local copy of the frontend (forms, queries, reports, code) that is stored on
their local hard disk.

"inungh" <inu...@xxxxxxxxx> wrote in message

news:f710633a-0936-4d34-a48f-5ecdb8836936@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On May 5, 2:44 pm, John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:





On Tue, 5 May 2009 07:13:51 -0700 (PDT), iccsi <inu...@xxxxxxxxx> wrote:
I just learned that MS Access has limit of number of concurrent users
of 255.

I would like know how does it count 1?
Does it really count one user login the system for one or it counts
all the connections like queries?

For example, it a report is running opens 10 queries.
Does it count 10 concurrent users?

Your information is great appreciated,

Each user counts only once. There are limits on the number of open
connections
but that's a different issue and shouldn't ordinarily cause problems.

HOWEVER... any multiuser application should certainly be "split" into a
shared
backend containing the tables, and individual frontends containing the
forms,
reports, queries, etc. Seehttp://www.granite.ab.ca/access/splitapp.htmfor
a
thorough discussion.
--

John W. Vinson [MVP]

Thanks for the message,
Do you know the limits on the number of open connections?
Thanks again,- Hide quoted text -

- Show quoted text -

My applications link to 10 backend databases to generate the reports.
The reports have tons sub reports.
User get Too many connections Can not open more databases error
message when user print the report from preview, but it works direct
print without preview.

I just wonder that MS Access rerun the queries and report when user
print the report from preview to make too many connections and the
error message.

Yes, I should move our databases to SQL server, since the complex of
the databases and reports.
It seems our applicaitons and databases reach limitations of MS
Access.

Thanks millions for helping,

.

Relevant Pages

  • Re: Wiki software for genealogy (long)
    ... store information ... ... it needs to allow connections to be made flexibly ... ... I like to have nice looking trees and printed reports as I don't get ... genealogical programs rather than the underlying database, ...
    (soc.genealogy.britain)
  • Querying 2 or more databases with ASP
    ... I am wanting to query a number of databases held on different servers. ... users table in the MySQL datebase. ... I have connections within Dreamweaver and this allows me to connect to ... Access using linked tables that allow me to run the queries that I ...
    (microsoft.public.inetserver.iis.activeserverpages)
  • Re: Remote Desktop wont accept a session
    ... Beyond that there have been reports that NAV 2005 worm protection causes ... > use this machine to control other machines via RD but I can't control ... > "The client could not connect to the remote computer. ... > busy to accept new connections. ...
    (microsoft.public.windowsxp.work_remotely)
  • Re: OT: Testing SMTP connections
    ... If we run nagios SMTP check on the machine hosting the receiving app, ... it sometimes reports timeouts. ... you telnet to port 8825 at the same ... connections to port 8825 and report if it doesn't get an answer with n ...
    (uk.rec.motorcycles)
  • Re: database links
    ... that is present in two separate files on two seperat databases. ... Of course, you can always make 2 connections, pull in all the data you need, ... Some databases however offer the possibility to make queries that span more ... eg Oracle or Postgres. ...
    (comp.lang.php)