473,387 Members | 1,882 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,387 software developers and data experts.

Concurrent users in Access Application

Hello,

I have designed a system using ms access. This system will be used by approximately 8 users. I would like to know what to do to ensure that several users can log into the system and update information as required. Is there any specific coding that must be done for this to work. Thanks for taking the time to ponder on this. It's a bit urgent.

Cheers,
Bobby23.
Oct 24 '07 #1
9 2508
NeoPa
32,556 Expert Mod 16PB
You need to :
  • Ensure that the Access options pertaining to record locking are set correctly on ALL installations of Access that are to be used.
  • Check ALL the code to ensure there is nothing that depends on there being only a single user to work correctly. Manual updates must be coded to include locking etc.
Oct 24 '07 #2
Hi,

Thanks for the response but could you please give an example?
Awaiting your response.
Cheers.
Oct 29 '07 #3
NeoPa
32,556 Expert Mod 16PB
You need to look in Tools / Options / Advanced.
This has the settings for single / multi-user. Clearly you need to select Default Open Mode of Sharde, but the other options depend on your database to a certain extent. Record locking is probably necessary for a completely safe system, but it's a killer on performance I understand.
A coding example would be any code that works by populating a table with temporary data. Any such data would have to be tagged with a unique ID indicating which user or PC it was from. Any code (or queries) would have to be designed to recognise only that data which is pertinent to the local user.
Oct 29 '07 #4
missinglinq
3,532 Expert 2GB
You don't say in your post; have you split the database into Front End/Back End yet?

Welcome to TheScripts!

Linq ;0)>
Oct 29 '07 #5
Hi there,

Thanks for the help.
I have not split the DB into a front and back end.
Is this necessary?

Cheers.
Oct 31 '07 #6
NeoPa
32,556 Expert Mod 16PB
It may be possible to do this without splitting the databases, but I wouldn't try it. It'll certainly be a great deal harder.
Oct 31 '07 #7
missinglinq
3,532 Expert 2GB
And multiple-users on a non-split database is sited by most experts as a surefire way to invite chronic corruption problems!

Linq ;0)>
Oct 31 '07 #8
ok ... thanks for the help. I will try that.
Cheers!!! :)
Nov 16 '07 #9
NeoPa
32,556 Expert Mod 16PB
Check out this new article (Front-End / Back-End (FE/BE)) for help with that Bobby :)
Nov 16 '07 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

12
by: CJM | last post by:
I'm setting up some web-based (ASP) reports that query an Access DB. I also want certain people to be able to access and manipulate the database directly. However, if the database is open in...
7
by: Robin Tucker | last post by:
I've been asked to turn our single-user database system into a multi-user system. At present, each user has a copy of the MSDE on their desktop machine and uses our program to access it. In...
1
by: Almarni | last post by:
Designed a database in Access 97 that runs on a 2000 server and is accessed by users using Windows 2000 client. Reported that no more than 3 users can use it. There is one database with the...
1
by: bluedolphin | last post by:
There seems to be a consensus that Access has a concurrent user limit of 200 users. I am working on a system that currently stands at approx. 1 gig and has a small number of users. However, there...
3
by: mgPA | last post by:
Short: How can I limit the number of concurrent logins to Access (2000) DB? Long: I seem to be having the problem discussed in previous postings of having more than 9 or 10 concurrent logins. ...
8
by: pnp | last post by:
Hi all, I've developed a win C# app that is actually database driven using SQL server 2000. The idea is that only one application will be installed on a server in a network and the program will be...
6
by: Bill Manring | last post by:
I have an ASP.NET application which my company sells comercially. We license on a concurrent user model, but we currently rely on the "honor" system for the customers to give us their best guess...
6
by: goraya | last post by:
This is design level discussion about web applications. How I design application that support 1 million concurrent requests??
2
by: mktselvan | last post by:
Hi, Existing running oracle application 11i (11.5.8) Database version is 8.1.7.4 There is any command / way to know the number of concurrent users for this application. ...
0
amitpatel66
by: amitpatel66 | last post by:
There is always a requirement that in Oracle Applications, the Concurrent Program need to be execute programatically based on certain conditions/validations: Concurrent programs can be executed...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.