Macros working on some systems, but not others

[Hoardling1 via AccessMonster.com]

Just moved from 2003 to 2007 Access.
Starting to get Macro failures.
I created a folder for all my users and gave that folder trusted permission.
The databases are updated daily. I am using the same database and my Macros
work fine.
Unfortunately, I have other user's who database's macros are not working
properly. Some of the macros are working, but not all. I believe that most
of the untrusted macros are failing on their systems. I am baffled that my
macros are working with the same setup as my users. I have the trusted
location exactly the same as theirs. Is there any extra settings for Macros
in Access, beside trusted location that would cause Macros to fail?

 

[Gina Whipp]

Hoardling1 ,

Are they all sharing the same database?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Steve Schapel]

Hoarding,

The trusted location has to be set up for each user's profile.

You should have a separate copy of the application running on the local
machine for each user, and linking to a common backend data file on the
server/share. Is that what you've done?

 

[Hoardling1 via AccessMonster.com]

Yes, I have a SQL Server 2008 Backend with Access 2007 FrontEnd. I have a
main copy of the Front End on a seperate server. Each morning when users log
on the database updates the file on their desktop to a folder. I gave this
specific folder Trusted Location rights. Now, on my system macros seems to
work fine, but some of my user's systems it doesn't work. What is
interesting there are some macros that work on their systems, I believe these
are the trusted macros and system macros that are working, and the non
working macros are not trusted - the Sendkeys etc... I know sendkeys are bad,
I inheritted this database and I general do VBA coding.

Hoarding,

The trusted location has to be set up for each user's profile.

You should have a separate copy of the application running on the local
machine for each user, and linking to a common backend data file on the
server/share. Is that what you've done?

Just moved from 2003 to 2007 Access.
Starting to get Macro failures.

[quoted text clipped - 12 lines]

Macros
in Access, beside trusted location that would cause Macros to fail?

 

[Gina Whipp]

Hoardling1,

That does not sound like a Front End per User but a Front End that everybody
uses. If that is the case then the Trusted Location is not as Steve said
"...per user..." which sounds like it could be the cause of your problem.
You really need a Front End on each persons local drive and then that drive
added to Trusted Location.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Yes, I have a SQL Server 2008 Backend with Access 2007 FrontEnd. I have a
main copy of the Front End on a seperate server. Each morning when users
log
on the database updates the file on their desktop to a folder. I gave
this
specific folder Trusted Location rights. Now, on my system macros seems
to
work fine, but some of my user's systems it doesn't work. What is
interesting there are some macros that work on their systems, I believe
these
are the trusted macros and system macros that are working, and the non
working macros are not trusted - the Sendkeys etc... I know sendkeys are
bad,
I inheritted this database and I general do VBA coding.

Hoarding,

The trusted location has to be set up for each user's profile.

You should have a separate copy of the application running on the local
machine for each user, and linking to a common backend data file on the
server/share. Is that what you've done?

Just moved from 2003 to 2007 Access.
Starting to get Macro failures.

[quoted text clipped - 12 lines]

Macros
in Access, beside trusted location that would cause Macros to fail?

 

[Hoardling1 via AccessMonster.com]

The front end is copied from the server to the individuals PC/ drive. So
each individual has a copy of their own front end. The front end is copied
to a folder and that folder is given Trusted Location. Everyone's folder is
named the same so I can give trusted rights to the folder and it will
universally go around as a trusted folder.

Hoardling1,

That does not sound like a Front End per User but a Front End that everybody
uses. If that is the case then the Trusted Location is not as Steve said
"...per user..." which sounds like it could be the cause of your problem.
You really need a Front End on each persons local drive and then that drive
added to Trusted Location.

Yes, I have a SQL Server 2008 Backend with Access 2007 FrontEnd. I have a
main copy of the Front End on a seperate server. Each morning when users

[quoted text clipped - 24 lines]

 

[Gina Whipp]

Hoardling1,

My misunderstanding... this tells us it's not a front end issue. What is
the Macro Security set at?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

The front end is copied from the server to the individuals PC/ drive. So
each individual has a copy of their own front end. The front end is
copied
to a folder and that folder is given Trusted Location. Everyone's folder
is
named the same so I can give trusted rights to the folder and it will
universally go around as a trusted folder.

Hoardling1,

That does not sound like a Front End per User but a Front End that
everybody
uses. If that is the case then the Trusted Location is not as Steve said
"...per user..." which sounds like it could be the cause of your problem.
You really need a Front End on each persons local drive and then that
drive
added to Trusted Location.

Yes, I have a SQL Server 2008 Backend with Access 2007 FrontEnd. I have
a
main copy of the Front End on a seperate server. Each morning when
users

[quoted text clipped - 24 lines]

Macros
in Access, beside trusted location that would cause Macros to fail?

 

[Hoardling1 via AccessMonster.com]

Disabel all macros with notification

Hoardling1,

My misunderstanding... this tells us it's not a front end issue. What is
the Macro Security set at?

The front end is copied from the server to the individuals PC/ drive. So
each individual has a copy of their own front end. The front end is

[quoted text clipped - 21 lines]

 

[Gina Whipp]

Hoardling1,

Okay a little confused here... You have the Macros disabled but some are
still working AND in some cases all are working? What do you want to
happen?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Disabel all macros with notification

Hoardling1,

My misunderstanding... this tells us it's not a front end issue. What is
the Macro Security set at?

The front end is copied from the server to the individuals PC/ drive.
So
each individual has a copy of their own front end. The front end is

[quoted text clipped - 21 lines]

Macros
in Access, beside trusted location that would cause Macros to fail?

 

[Hoardling1 via AccessMonster.com]

Oops my gig, that setting is for Macros not in trusted locations.
I want all macros to work, that is why every user has a folder that is a
trusted location with the database frontends in them.
Now, my frontend macros work great, and I get the same Access frontend copy
that everyone else does. Some of my users macros aren't working. One would
think there is some kind of security setting in Windows VISTA or folders that
isn't allowing macros to work..???, but yet I thought Access macros would
only be controlled by Access.

Hoardling1,

Okay a little confused here... You have the Macros disabled but some are
still working AND in some cases all are working? What do you want to
happen?

Disabel all macros with notification

[quoted text clipped - 9 lines]

 

[Gina Whipp]

In Windows Vista, right click on the shortcut and see if there is an option
'Run As Administrator' and see if this differs on a machine that works and
one that is giving you problems.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Oops my gig, that setting is for Macros not in trusted locations.
I want all macros to work, that is why every user has a folder that is a
trusted location with the database frontends in them.
Now, my frontend macros work great, and I get the same Access frontend
copy
that everyone else does. Some of my users macros aren't working. One
would
think there is some kind of security setting in Windows VISTA or folders
that
isn't allowing macros to work..???, but yet I thought Access macros would
only be controlled by Access.

Hoardling1,

Okay a little confused here... You have the Macros disabled but some are
still working AND in some cases all are working? What do you want to
happen?

Disabel all macros with notification

[quoted text clipped - 9 lines]

Macros
in Access, beside trusted location that would cause Macros to
fail?

 

[Hoardling1 via AccessMonster.com]

Well, I tried to use the database as Administartor. I logged in as the
Administrator and it still showed the same problems. This is baffling for me,
I don't use macros a lot. I logged as sysadmin on my machine and it ran the
macros fine, so it isn't just my profile. I wonder if there is something in
registry on each machine, I wouldn't really know where to look though.

In Windows Vista, right click on the shortcut and see if there is an option
'Run As Administrator' and see if this differs on a machine that works and
one that is giving you problems.

Oops my gig, that setting is for Macros not in trusted locations.
I want all macros to work, that is why every user has a folder that is a

[quoted text clipped - 20 lines]

 

[Gina Whipp]

Take a look here and see if there is anything that might *fix* your issue...
http://allenbrowne.com/bug-17.html Specifically, the one regarding
Reference Permissions which has to do with the Registry.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Well, I tried to use the database as Administartor. I logged in as the
Administrator and it still showed the same problems. This is baffling for
me,
I don't use macros a lot. I logged as sysadmin on my machine and it ran
the
macros fine, so it isn't just my profile. I wonder if there is something
in
registry on each machine, I wouldn't really know where to look though.

In Windows Vista, right click on the shortcut and see if there is an
option
'Run As Administrator' and see if this differs on a machine that works and
one that is giving you problems.

Oops my gig, that setting is for Macros not in trusted locations.
I want all macros to work, that is why every user has a folder that is a

[quoted text clipped - 20 lines]

in Access, beside trusted location that would cause Macros to
fail?

 

[Hoardling1 via AccessMonster.com]

Interesting, I will definately look into this one.

Thank You.

Take a look here and see if there is anything that might *fix* your issue...
http://allenbrowne.com/bug-17.html Specifically, the one regarding
Reference Permissions which has to do with the Registry.

Well, I tried to use the database as Administartor. I logged in as the
Administrator and it still showed the same problems. This is baffling for

[quoted text clipped - 15 lines]

 

[Hoardling1 via AccessMonster.com]

That was it!!!!!!!!!!
The UAC on my machine was off and my user's UAC was on. I turned mine on and
I started getting the same problems. Now to talk to my network guy and see
if we should keep the UAC on or off.

THANK YOU
and also THANK YOU allen browne for having that site.

Take a look here and see if there is anything that might *fix* your issue...
http://allenbrowne.com/bug-17.html Specifically, the one regarding
Reference Permissions which has to do with the Registry.

Well, I tried to use the database as Administartor. I logged in as the
Administrator and it still showed the same problems. This is baffling for

[quoted text clipped - 15 lines]

 

[Gina Whipp]

You're welcome!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

That was it!!!!!!!!!!
The UAC on my machine was off and my user's UAC was on. I turned mine on
and
I started getting the same problems. Now to talk to my network guy and
see
if we should keep the UAC on or off.

THANK YOU
and also THANK YOU allen browne for having that site.

Take a look here and see if there is anything that might *fix* your
issue...
http://allenbrowne.com/bug-17.html Specifically, the one regarding
Reference Permissions which has to do with the Registry.

Well, I tried to use the database as Administartor. I logged in as the
Administrator and it still showed the same problems. This is baffling
for

[quoted text clipped - 15 lines]

in Access, beside trusted location that would cause Macros to
fail?