John-
Yes, you can assign permissions to macros that you can see in the Nav Pane,
but not to Embedded Macros.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of jfakes.rm
Sent: Friday, April 05, 2013 3:58 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Bugs in Access 2010
Are there any permissions assign to the macros? I have a db that uses user
level permissions (nightmare) and I had a user that didn't have permission
to view a query used in the macro so part of it worked, part didn't.
John F
--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "dnwinberry"
<winberry.doyce@...> wrote:
>
> Jim,
>
> Adding to what Bill and John said...
>
> I had an issue a couple of weeks ago where one PC had Windows 7 service
pack 1 and another did not. The one that did not had some problems with
Access 2010 that went away after I installed Windows 7 Service Pack 1. You
might check to make sure you have the same Windows and Service packs on both
machines too.
>
> Doyce
>
> --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Mosca" <wrmosca@>
wrote:
> >
> > Jim-
> >
> > Adding to what John asked...
> >
> > Does the user's machine have the latest Office updates? Is the version
and build
> > the same as your boss's Access?
> >
> >
> >
> > Regards,
> >
> > Bill
> >
> >
> >
> > From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> > [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of John
Viescas
> > Sent: Thursday, April 04, 2013 11:00 AM
> > To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> > Subject: RE: [MS_AccessPros] Bugs in Access 2010
> >
> >
> >
> >
> >
> > Jim-
> >
> > Two questions:
> >
> > 1) What is the error on the "user" machine?
> >
> > 2) What are the differences between the "user" machine and th "boss"
> > machine?
> >
> > John Viescas, Author
> >
> > Microsoft Access 2010 Inside Out
> >
> > Microsoft Access 2007 Inside Out
> >
> > Microsoft Access 2003 Inside Out
> >
> > Building Microsoft Access Applications
> >
> > SQL Queries for Mere Mortals
> >
> > http://www.viescas.com/
> >
> > (Paris, France)
> >
> > From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of
luvmymelody
> > Sent: Thursday, April 04, 2013 7:35 PM
> > To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > Subject: [MS_AccessPros] Bugs in Access 2010
> >
> > Hello all,
> >
> > Here is the deal, we support 77 databases, many departments and many
users.
> > We experience bugs all the time as far as we are concerned yet there is
> > really no real answers and they are not explainable.
> >
> > For example a user complained that a macro with several queries was not
able
> > to produce a result of any kind and therefore came to my boss and I for
> > support. My boss ran the macro on her own desktop. The macro and all
> > subsequent queries ran without incident. Yet the user wanted the macro
and
> > queries fixed. Others can run the macro without issues. Yet the user
wants
> > it fixed. Our Boss also wants it fixed. It is really difficult to fix
> > something that is really not broken in the database.
> >
> > My boss rebuilt the macro and the queries, ran the macro on her machine
in
> > front of the user and it worked. The user went to her desk and the macro
> > failed. The database is on a shared network drive. My boss then tried to
> > open it and run the macro and it worked without problems, in front of
the
> > user. The user then went back to her desk and the macro failed for her.
> >
> > Now Our boss wants answers. My boss has asked that I ask the user group
to
> > weigh in on this topic. We have seen other bugs that we cannot explain
to
> > users and they are getting tired of the problems. The bugs are not so
> > prevalent that it is every day occurrences. It is like a plane crash in
the
> > media. It is made to be a big deal, yet thousands are killed or hurt in
car
> > crashes every day, and the media does not so much as air them.
> >
> > If anyone can give an answer to satisfy users and upper management of
known
> > and unknown bugs would be helpful to keeping the peace.
> >
> > Thank You For all messages
> >
> > Jim Wagner
> >
> > [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]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar