Brad,
Let's see how many of these I can knock off...
1. & 2.
-Yes, the database should be split with the backend on the Server and the front ends on everyone's local. For more information see...
Does everyone have their own front end? Are their front ends installed on their drive and the back-end on a shared drive? Is the database opening in shared mode? Perhaps the below will help...
http://www.members.shaw.ca/AlbertKallal/Articles/split/
http://allenbrowne.com/ser-01.html
You may also want to take a look at MVP Tom Wickerath's article...
http://www.accessmvp.com:80/TWickerath/articles/multiuser.htm
To handle the update of multiple front ends see...
http://www.autofeupdater.com/
If each user needs Access you can install the Runtime…
Access 2007
http://www.microsoft.com/downloads/details.aspx?familyid=d9ae78d9-9dc6-4b38-9fa6-2c745a175aed&displaylang=en
Access 2010
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=57a350cd-5250-4df6-bfd1-6ced700a6715&displaylang=en
3. Ribbon not my area as I don't load the ribbon. Users have to work off the buttons on my forms and that way I control what they can do.
4. The backend would be backed up by whatever you are using to back up the Server. I usually keep a copy of the front end in a subfolder of the backend folder on the Server just in case someone manages to crash their machine. I can either go in and load a new front end for them or tell them how to navigate to it and copy it to their local drive.
Thanks,
Gina Whipp
2010 - 2011 Microsoft MVP (Access)
www.regina-whipp.com
From: Bradley
Sent: Saturday, July 16, 2011 2:51 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Multiple User Issues
Hello, I am creating a simple time tracking database for my department at work. It will be used by about ten people. I don't know anything about multiple user and security issues and have a few questions. Any advice you can give me will be helpful. I am using Access 2007 and my experience level is beginner. A zip file of the database (still in progress) is in the "PTS Time Tool" folder as "TimeTool_3."
1) How do I make the database available to multiple users at the same time? Currently, it can only be used by one person at a time.
2) Do I need to split the database? If so, how do I do that, and what do I need to know about making future changes to tables and objects?
3) A mid-level security arrangement is appropriate for my database. Currently, I have a simple "login form" password system, which is fine for now. How do I limit what users can do with the ribbon, and how do I keep them from making changes to tables and objects?
4) What is the best way to backup the database?
Thanks,
Brad
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar