yellow triange

T

terryc

Some of the lines in my macro have a yellow triangle with an exclamation
point. What does that mean? The macro seems to run fine.
 
S

Steve Schapel

Terry,

The yellow triangle icon indicates a macro action which will only work if
the database is deployed to a "trusted location".
 
T

terryc

Thanks Steve. Then it puzzles me why all of the lines aren't marked the same.
When I open the database in a trusted location, I would think everything in
the database is then from a trusted location. The database was built years
ago, probably office 97. In 2007 the triangles appear. In 2003 they don't. I
just want to be sure everything is trusted when my employees use the mdb
irregardless of the Office version they are using.
 
S

Steve Schapel

Terry,

No, it doesn't indicate whether the database is trusted or not. It is an
indication that these actions will not work *if* the database was to be used
in a non-trusted state. It only applies to some macro actions, not all.
Some macro actions will continue to work in a non-trusted database. And
this feature is only operative in Access 2007, it is a new feature.
 
T

terryc

Thanks again, Steve.

Steve Schapel said:
Terry,

No, it doesn't indicate whether the database is trusted or not. It is an
indication that these actions will not work *if* the database was to be used
in a non-trusted state. It only applies to some macro actions, not all.
Some macro actions will continue to work in a non-trusted database. And
this feature is only operative in Access 2007, it is a new feature.
 
J

Jennifer B

I am using access 2007 and have the yellow triangle on the majority of my macros. I am trying to follow the advice of deploying the database to a trusted location but how do I accomplish that? I have the database on my hard drive, do I need to change an option somewhere to indicate my hard drive is a trusted source? The marco I am currently working with is transfering data from a network drive, do I need to indicate somewhere that this network drive is trusted? I appreciate any help you can provide.
Thanks,
Jennifer



Steve Schapel wrote:

Terry,The yellow triangle icon indicates a macro action which will only work
06-Feb-09

Terry

The yellow triangle icon indicates a macro action which will only work i
the database is deployed to a "trusted location"

-
Steve Schapel, Microsoft Access MVP

Previous Posts In This Thread:

yellow triange
Some of the lines in my macro have a yellow triangle with an exclamatio
point. What does that mean? The macro seems to run fine.

Terry,The yellow triangle icon indicates a macro action which will only work
Terry

The yellow triangle icon indicates a macro action which will only work i
the database is deployed to a "trusted location"

-
Steve Schapel, Microsoft Access MVP

Thanks Steve. Then it puzzles me why all of the lines aren't marked the same.
Thanks Steve. Then it puzzles me why all of the lines aren't marked the same.
When I open the database in a trusted location, I would think everything in
the database is then from a trusted location. The database was built years
ago, probably office 97. In 2007 the triangles appear. In 2003 they don't. I
just want to be sure everything is trusted when my employees use the mdb
irregardless of the Office version they are using

:

Terry,No, it doesn't indicate whether the database is trusted or not.
Terry

No, it doesn't indicate whether the database is trusted or not. It is an
indication that these actions will not work *if* the database was to be used
in a non-trusted state. It only applies to some macro actions, not all.
Some macro actions will continue to work in a non-trusted database. And
this feature is only operative in Access 2007, it is a new feature

--
Steve Schapel, Microsoft Access MV


Re: yellow triange
Thanks again, Steve

:

Steve - A follow-up question on this aspect if I may pls.
Steve - A follow-up question on this aspect if I may pls. I am using Acces
2007, but saving my DB in 2003 format (because that is what is at work). I
too, have yellow triangles dotted across a range of macros in my databas
resulting if I understand it right from SetValue action. Often in my DB, th
condition associated with SetValue revolves around the trusted state. Th
condition sometimes results - and this is part of the problem - in the erro
message telling me that SetValue cannot be run in disabled mode. But it work
in other fine in other macros elsewhere in the DB. So I am gettin
inconsistent results. My questions ... If the triangle feature is ne
inAccess 2007, is it therefore safe to delete those lines from the macros i
my 2003-formatted DB without causing problems? If I need to retain thos
lines, what then is the equivalent action I should use as a substitute fo
SetValue? Thanks, Steve, in advance

Regard

Chri

:


Submitted via EggHeadCafe - Software Developer Portal of Choice
File-Based Cache for Web and non-Web Apps plus Extend ASP.NET 4.0 OutputCacheProvider
http://www.eggheadcafe.com/tutorial...dfe-9f7a28f4d58e/filebased-cache-for-web.aspx
 
S

Steve Schapel

Jennifer,

To establish the folder where you have the database as a Trusted Location,
follow these steps:

Office (pizza) button => Access Options => Trust Center => Trust Center
Settings => Trusted Locations => Add New Location
 
G

Gina Whipp

Jennifer,

If you want to deploy this to other Users have a look at...

http://accessjunkie.com/faq_33.aspx

--
Gina Whipp
2010 Microsoft MVP (Access)

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

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

in message I am using access 2007 and have the yellow triangle on the majority of my
macros. I am trying to follow the advice of deploying the database to a
trusted location but how do I accomplish that? I have the database on my
hard drive, do I need to change an option somewhere to indicate my hard
drive is a trusted source? The marco I am currently working with is
transfering data from a network drive, do I need to indicate somewhere that
this network drive is trusted? I appreciate any help you can provide.
Thanks,
Jennifer



Steve Schapel wrote:

Terry,The yellow triangle icon indicates a macro action which will only work
06-Feb-09

Terry,

The yellow triangle icon indicates a macro action which will only work if
the database is deployed to a "trusted location".

--
Steve Schapel, Microsoft Access MVP

Previous Posts In This Thread:

yellow triange
Some of the lines in my macro have a yellow triangle with an exclamation
point. What does that mean? The macro seems to run fine.

Terry,The yellow triangle icon indicates a macro action which will only work
Terry,

The yellow triangle icon indicates a macro action which will only work if
the database is deployed to a "trusted location".

--
Steve Schapel, Microsoft Access MVP

Thanks Steve. Then it puzzles me why all of the lines aren't marked the
same.
Thanks Steve. Then it puzzles me why all of the lines aren't marked the
same.
When I open the database in a trusted location, I would think everything in
the database is then from a trusted location. The database was built years
ago, probably office 97. In 2007 the triangles appear. In 2003 they don't. I
just want to be sure everything is trusted when my employees use the mdb
irregardless of the Office version they are using.

:

Terry,No, it doesn't indicate whether the database is trusted or not.
Terry,

No, it doesn't indicate whether the database is trusted or not. It is an
indication that these actions will not work *if* the database was to be used
in a non-trusted state. It only applies to some macro actions, not all.
Some macro actions will continue to work in a non-trusted database. And
this feature is only operative in Access 2007, it is a new feature.

--
Steve Schapel, Microsoft Access MVP


Re: yellow triange
Thanks again, Steve.

:

Steve - A follow-up question on this aspect if I may pls.
Steve - A follow-up question on this aspect if I may pls. I am using Access
2007, but saving my DB in 2003 format (because that is what is at work). I,
too, have yellow triangles dotted across a range of macros in my database
resulting if I understand it right from SetValue action. Often in my DB, the
condition associated with SetValue revolves around the trusted state. The
condition sometimes results - and this is part of the problem - in the error
message telling me that SetValue cannot be run in disabled mode. But it
works
in other fine in other macros elsewhere in the DB. So I am getting
inconsistent results. My questions ... If the triangle feature is new
inAccess 2007, is it therefore safe to delete those lines from the macros in
my 2003-formatted DB without causing problems? If I need to retain those
lines, what then is the equivalent action I should use as a substitute for
SetValue? Thanks, Steve, in advance.

Regards

Chris

:


Submitted via EggHeadCafe - Software Developer Portal of Choice
File-Based Cache for Web and non-Web Apps plus Extend ASP.NET 4.0
OutputCacheProvider
http://www.eggheadcafe.com/tutorial...dfe-9f7a28f4d58e/filebased-cache-for-web.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top