Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

Multi-User Runtime

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
mcj
Asked:
mcj
  • 2
2 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
You can 'split' the mdb into a Front End and a Back End ... see this link:



http://support.microsoft.com/kb/304932
0
 
Patrick MatthewsCommented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
And you are probably going to need a UserID field also ... to delineate between users.

mx
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now