Solved

Multi-User Runtime

Posted on 2008-06-17
5
197 Views
Last Modified: 2013-11-29
I've made a very simple task management database for a client. The original scenario was like this: 20 employees would each need to track (for themselves) their project tasks. One database would be designed and made a runtime and the runtime would be deployed on all 20 workstations. Fine, no problem. Works great.

Now user Bob and user Jane say: "Unlike most of the employees here, the two of us actually share these tasks." Two people at two workstations, but one role.

How do I tweak the database (or is it just an issue of how I install it?) so that these two can both use the same database?

Note: If they can simultaneously use it, that's gravy here and I'd be happy about that, but they are OK if only one can use it at a time as long as they can each use it from their desktop.
0
Comment
Question by:mcj
  • 2
5 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 63 total points
ID: 21807447
You can 'split' the mdb into a Front End and a Back End ... see this link:



http://support.microsoft.com/kb/304932
0
 
LVL 92

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 62 total points
ID: 21807784
Hello mcj,

MX's suggestion would enable multi-user capabilities.  Of course, if your current schema has a one-to-one
assignment of tasks to people, now you are going to need a one-to-many, and thus probably need a
junction table to hold the assignments...

Regards,

Patrick
0
 
LVL 75
ID: 21807791
And you are probably going to need a UserID field also ... to delineate between users.

mx
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Attachment field in SQL 3 28
MS Access Delete All Excel sheets 1 9
Trying to force an answer in a combobox 7 18
Modify report 8 6
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question