Senin, 18 Juli 2011

Re: [MS_AccessPros] Re: Multiple User Issues

 

Brad,

Yep, Albert's link has been updated but I have not updated all of mine. Here you go...

http://www.kallal.ca/Articles/split/index.htm

1. No need to worry about *Shared* because each database FE belongs to that person, at least it's never been a problem for me. However, for your peace of mind you may set the Default Open to *Shared*.

2. They don't have to have the FE on their desktop but it must be on their local or you still take a chance of corruption with multiple Users sharing the same file.

3. To hide the ribbon...

Docmd.ShowToolBars "Ribbon",acToolBarNo

4. I do not give my Users a chance to use any of the menus or toolbars. They are stuck with the button I give them. In your case, I would check to see what they would like to do and see if that is an option I want then to do and then add it to the appropriate form.

Thanks,
Gina Whipp
2010 - 2011 Microsoft MVP (Access)

www.regina-whipp.com

From: Bradley
Sent: Monday, July 18, 2011 4:39 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Multiple User Issues

Gina, thanks for your help! I studied your suggestions and links and have a few more questions.

Please check your Albert Kallal link. It sounds like it will answer a lot of my questions, but it appears to be broken. Please re-send.

My questions are pretty elementary, but bear with me. Currently, everyone in my department has Access 2007 installed on their PC's. I ran the splitter wizard at home on a test file to see how it works. It's easier than I thought. My questions are:

1) Does simply splitting the file and putting a copy of the front end on everyone's PC allow everyone to use the database at the same time, or is there something else I need to do to put it into "Shared Mode"?

2) Is it necessary for each user to copy the front end to their PC, or could they also create a desktop shortcut to the main front end file?

3) How do I get rid of the ribbon in 2007? I didn't know I could do that.

4) What are your suggestions and tips for setting the startup options and creating the best user interface? I also like users to work off the buttons on my forms as much as possible, but is there a place for limited menu/ribbon options?

Thanks,

Brad

--- In mailto:MS_Access_Professionals%40yahoogroups.com, "Gina Whipp" <classon@...> wrote:
>
> 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: mailto:MS_Access_Professionals%40yahoogroups.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]
>

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar