Gina, the link has a lot of good information. I'm still working through it.
I have a few more questions:
1) It looks like I need to insert a line of code somewhere to hide the ribbon. I'm a beginner with VBA and am a little confused about what to do. I did some research on the web and got myself even more confused. Where do I put your line of code?
2) Please explain Duane's suggestion: "Actually the anwer in 3. hould be minu one."
3) After hiding all the menus and toolbars, is there an easy way to make them "unhidden" if I need to make changes to the database?
4) I discovered that I can create a button to delete a record. That is something that I previously thought could only be done on the ribbon. I'm going to add a "Delete Record" button to my main data entry form. Since I like your idea of getting rid of all menus and toolbars, what are some other buttons I should create to make a good user interface? It sounds like you might have a standard way to set up your forms with some basic command buttons.
5) As you can see on my sample database, I have a "View Datasheet" button that allows users to view and change their records in datasheet view. Do you think that is a good idea, or is it best to have users do everything in form view?
Thanks,
Brad
--- In MS_Access_Professionals@yahoogroups.com, "Gina Whipp" <classon@...> wrote:
>
> Thanks Duane!
>
> Thanks,
> Gina Whipp
> 2010 - 2011 Microsoft MVP (Access)
>
> www.regina-whipp.com
>
> From: Duane Hookom
> Sent: Monday, July 18, 2011 10:05 AM
> To: Access Professionals Yahoo Group
> Subject: RE: [MS_AccessPros] Re: Multiple User Issues
>
>
> Actually the anwer in 3. hould be minu one
>
> Docmd.ShowToolBar "Ribbon", acToolBarNo
>
> Duane Hookom
> M Acce MVP
>
>
>
>
> To: MS_Access_Professionals@yahoogroups.com
> From: classon@...
> Date: Mon, 18 Jul 2011 09:53:31 -0400
> Subject: 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]
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar