473,320 Members | 2,180 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

MS-Access 2003 Back End Maximum Users

I have a Back End database (split) that is on a smokin' hot machine
(dual processor, 2 gig RAM, XP Pro SP2) and I'm getting an error that
says the database (back end file) is "opened exclusively" by someone
else.

I looked at the number of sessions and noticed that when the number of
sessions were at 10, any new user launching the front end would get
the "exclusive" error message.

There is no security in place and no login required.

I thought there would be a higher limit than this.

Is there some kind of limit to the number of sessions or files opened
for the XP machine (with the back end database)? If so, can that
number be raised to allow more users to connect?

Also, if the limit is a Microsoft license issue, where they would want
you to buy a Server OS, how does this speak to all the development
over the years promoting "front end/back end" senario? Is it
understood, all this time, that these applications (as described in
Developer books, magazines and articles, etc.) would "conveniently" be
in an environment where there are 10 or less simultaneous users?
I'm only asking because, NONE of the training or advice ever said,
"oh, by the way, this multi-user situation can only have a max of 10
concurrent users, unless you are deploying on a MS-Server
environment..."

I'm not looking for a hundred, but 10! Geeze, that seems to be a bit
constraining, no?
Thanks in Advance

Feb 21 '07 #1
1 6857
Is there some kind of limit to the number of sessions or files opened
for the XP machine (with the back end database)? If so, can that
number be raised to allow more users to connect?
the maximum number of connections supported on a network in
windows xp is 10. This limitation has nothing to do with
ms-access.
Also, if the limit is a Microsoft license issue, where they would want
you to buy a Server OS, how does this speak to all the development
over the years promoting "front end/back end" senario?
The issue is not related in any way, shape, or form. If you use a
server based edition of windows...no such limit exists.
I'm only asking because, NONE of the training or advice ever said,
"oh, by the way, this multi-user situation can only have a max of 10
concurrent users, unless you are deploying on a MS-Server
environment..."
Well, it is the same for any application. Internet connection sharing,
likely printers...whatever it is ..the limit is 10 users. It not a ms-access
issue, and it assumed that you have competent computer people.

I mean, where does it say when deploying ms-access that you have to
have enough disk space? It NEVER mentions disk space, but only
a fool would stand here and complain about the fact that the ms-access
manual does not state you need enough disk space to deploy your application.
Why is that detail left out? (answer: because we have to assume a certain
level of competence here).

I am VERY VERY hard pressed to have seen ANY company have 10+ users, and not
have some type of server for this environment. So, sure, I known many
companies with 3, or even 8 users same some money, and purchase a windows xp
edition in place of the server edition. however, any competent computer
support person setting up a network is going to know that you want something
better then the desktop edition of windows to server and support more then
10 users.

Is the 10 user number somewhat arbitrary? Sure, perhaps it is, but it comes
down to using the right horse for the right course.
I'm not looking for a hundred, but 10! Geeze, that seems to be a bit
constraining, no?
Hum, the 10 limit rarely comes up in this newsgroup. If you search posts, I
think we are luck to see one or two posts on this a year (and that with in
excess of 20,000+ posts on JUST ms-access alone in ONE MONTH!!!). So, it is
VERY rare to see this issue come up in this newsgroup. If this comes up so
rare
in this newsgroup..then you have to start thinking it not a big deal.

If you have a desktop machine, and
you are allowing 10 users to access resources on that machine, you likely
are risking stability, and users data. You likely are using that
desktop machine in a wrong way. I guess for some, 10 is tons of
users and in some environments you likely would be fired for allowing
10 users to access resources on your desktop machine.

I know if
we allowed a network person to setup a system for 20 users, and
the server was a desktop edition of windows..that dude would be
in heap of trouble...

By the time
a company with *COMPETENT* computer uses gets to having
a server with MORE then 10 users...it likely high time they use
the appropriate version of windows for that purpose..don't you think?
(well, actually..you don't think that!!!).

So, the network limit is rarely a problem, and it not a ms-access issue, but
will depend on the version of windows
you use.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Feb 21 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Don Wash | last post by:
Hi All! I do not find any relevant newsgroups to post this question so I just posted to this VB DotNet and General DotNet groups. I'm trying to create a VB.NET application that will scan...
0
by: Christian McArdle | last post by:
REQUEST FOR DISCUSSION (RFD) unmoderated group comp.os.ms-windows.programmer.win64 This is a formal Request For Discussion (RFD) to create comp.os.ms-windows.programmer.win64 as an unmoderated...
0
by: Christian McArdle | last post by:
REQUEST FOR DISCUSSION (RFD) unmoderated group comp.os.ms-windows.programmer.win64 This is a formal Request For Discussion (RFD) to create comp.os.ms-windows.programmer.win64 as an unmoderated...
3
by: Christian McArdle | last post by:
REQUEST FOR DISCUSSION (RFD) unmoderated group comp.os.ms-windows.programmer.64bit This is a formal Request For Discussion (RFD) to create comp.os.ms-windows.programmer.64bit as an unmoderated...
7
by: Dave | last post by:
We are trying to migrate a MS SQL server app to DB2 8.1 Linux platform. Our database has got about 300+tables with total size - 150 GB We are using MS SQL's BCP utility to extract data from...
2
by: Mikey | last post by:
Sample VB .NET source code to create mailing labels or customized letters using MS Word MailMerge This VB .NET source code will start MS Word and call methods and set properties in MS Word to...
6
by: Anony Mous | last post by:
Hi, We've got some clients that are concerned about running Postgresql 7.3.4 on a Win2k Server box, alongside MS SQL Server. I've been running pg on my XP machines for a long time now (with...
2
by: =?Utf-8?B?QW50aG9ueSBSb2RyaWd1ZXosIERCQQ==?= | last post by:
Hi! I downloaded MS Visual Web Developer 2005 Express Edition, MS .NET Framework SDK v2.0, and MS SQL Server 2005. Subsequently, I bought MS Visual Studio 2005 Professional Edition. 1) Are...
1
by: Dr T | last post by:
Hi! I downloaded MS Visual Web Developer 2005 Express Edition, MS .NET Framework SDK v2.0, and MS SQL Server 2005. Subsequently, I bought MS Visual Studio 2005 Professional Edition. 1) Are...
0
by: InnoSol | last post by:
Hi All, I am not familiar with MS SQL Server. I have one MS Excel file with datas such as date, name, Address such that. My client given one software to type those datas. The typed datas are...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.