Hyperlink value crashes Access

[FlyGuy]

If I assign a hyperlink value to a cmd button or in code using the follow
hyperlink method, using a link value like
http://www.cookbookplus.com/Activate.aspx, the page is accessed [Internet
Explorer] OK, but the Access app crashes every time.

However, if I instead just target the main web site
http://www.cookbookplus.com that page is opened AND Access does not crash.

Crashes also occur if a hyperlink field is populated with
http://www.cookbookplus.com/Activate.aspx

Again, that page is opened in IE, but Access crashes.
The targeted page is a simple, safe, publicly available page.

Am I doing something wrong; are .aspx pages prohibited in link values?
--
Thanks,

FlyGuy

[Alex Dybenko]

Hi,
try to use ShellExecute API instead of FollowHyperlink method:
http://www.mvps.org/access/api/api0018.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

"FlyGuy" <Fly...@discussions.microsoft.com> wrote in message
news:774F16AF-F170-4DA8...@microsoft.com...

[FlyGuy]

Thanks Alex; unfortunately the shell function will not solve my problem.

I have another Access 2007 database that is a collection of links to files
everywhere (like a favorites on steroids).

That DB has many records (hyperlink field) that have aspx values; those
links worked until just recently.

So something in Access [Windows security?] has changed.

I need to have .aspx links work like they used to.

This issue is not DB specific, bu seems to only affect Access 2007 links;
.aspx links in Word docs work.

Can anyone reproduce this issue?

It is delaying a development project.
--
Thanks,

FlyGuy

"Alex Dybenko" wrote:

> .
>

[Gina Whipp]

FlyGuy,

What line are you using? This...

Application.FollowHyperlink Me.TextFieldWithTheURL

...worked for me.

--
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

"FlyGuy" <Fly...@discussions.microsoft.com> wrote in message
news:774F16AF-F170-4DA8...@microsoft.com...

[FlyGuy]

I just tried your suggestion; with .aspx link, page opens, but Access still
crashes.

In all cases, Access looks OK except for circle cursor indicating something
happening; Task Manager shows 100% cpu. Any attempt to interact with Access
UI causes hard crash. Only out is cancel process with Task Manager.

Something bizarre going on with my Access 2007.

Again, same issue with different database files and different link methods.

Happens with both Access 2007 (full version) and Access 2007 runtime apps.

Non .aspx URLs seem to work OK.

Desparate for more insight; I need to get this resolved.

--
Thanks,

FlyGuy

"Gina Whipp" wrote:

> FlyGuy,
>
> What line are you using? This...
>
> Application.FollowHyperlink Me.TextFieldWithTheURL
>

> ....worked for me.

> .
>

[Gina Whipp]

FlyGuy,

What version of IE? What version of Windows? Is your database in a Trusted
Location? Are you using macros?

--
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

"FlyGuy" <Fly...@discussions.microsoft.com> wrote in message

news:6DEF3B8D-C430-402F...@microsoft.com...

[FlyGuy]

Seems as if only hyperlinks to ...xxx.aspx addresses cause issue; my company
web site start page is http://www.cookbookplus.com/Welcome.aspx ; this now
causes crash; but using http://www.cookbookplus.com gets you to same page
without crash.

--
Thanks,

FlyGuy

[FlyGuy]

I even get crash after navigating to http://support.microsoft.com/Default.aspx

[Gina Whipp]

FlyGuy,

You did not answer my questions... also what is your home page?

--
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

"FlyGuy" <Fly...@discussions.microsoft.com> wrote in message

news:F75BB0BD-1448-4B64...@microsoft.com...

[FlyGuy]

My home page is http://www.cookbookplus.com/
--
Thanks,

FlyGuy

"Gina Whipp" wrote:

> .
>

[FlyGuy]

Gina, I tried using Application.FollowHyperlink Me.TextFieldWithTheURL (with
a ...xxx.aspx address)
as on_click for a button; web page was navigated to but Access crashed.

Issue crashes occur regardless of method used for link execution, and again,
only with .aspx addresses.

Windows Vista Business, IE 8; PC fully updated.

All Access data bases that exhibit behavior have been programed with VBA.
One DB has macros for customizing ribbon.

The links used to work until very recently; perhaps related to a new Access
app I worked on that has macros?

I need to check on macro settings and trusted locations; will post more
tomorrow.

Thanks.
--
Thanks,

FlyGuy

"Gina Whipp" wrote:

> .
>

[FlyGuy]

Access 2007 databases that exhibit issue are in trusted locations.

Macro settings are disable all with notification.

--
Thanks,

FlyGuy

"Gina Whipp" wrote:

> .
>

[Gina Whipp]

FlyGuy,

Try enabling macros... I was hoping I had the same environment but I don't,
not on Vista and that might be why I can't seem to reproduce. Just to
confirm, if you open IE and navigate to the page without Access IE opens the
page fine?

--
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

"FlyGuy" <Fly...@discussions.microsoft.com> wrote in message

news:2C9982F3-B023-470D...@microsoft.com...

[FlyGuy]

Gina,

I can navigate to any ...xxx.aspx page directly in IE, or from any
...xxx.aspx link in other Office 2007 applications (like Word); I just cannot
navigate to ...xxx.aspx links (anymore) from within Access 2007.

I run full version of Access 2007; I also run several Access 2007 runtime
apps; makes no difference.

Not sure what you mean by "enable macros"?

But I'll look and change settings in Trust Center to see if that makes a
difference.
--
Thanks,

FlyGuy

"Gina Whipp" wrote:

> .
>

[FlyGuy]

Gina,

I posted back earlier this AM; but I do not see it.

I can open IE and navigate directly to any ...xxx.aspx pages OK.

I changed Access Trust Center/Trust Center Settings/Marcos to Enable all
macros.

I then opened my links database app and my first use of a link to
http://www.cookbookplus.com/Activate.aspx worked, and did not crash Access.

I then reset to disable with notification and got crashes.

I reset back to enable macros and now I just get crashes (again) every time.

A hyperlink field is not a macro; aspx pages are not marcros.

I have toggled the macro settings several times in different Access 2007
databases; I cannot get it to work again.

I note that the one time it did work (1st attempt after setting enable
macros) that the navigation to aspx page happened immediately.

Otherwise (when navigation to aspx causes crashes) the navigation takes
several seconds, and I usually see a blank browser window before the .aspx
page loads. But then, Access is always crashed.

There seems to be a major security conflict or bug here.

Your thoughts?
--
Thanks,

FlyGuy

"Gina Whipp" wrote:

> .
>

[Gina Whipp]

FlyGuy,

I am just as confused as you are and it makes it difficult because I can't
reproduce OR get it to happen on my machine. But I am going to put a shout
out to see if *anyone* has any background in this issue.

Just to be on the safe side, are ALL your updates up-to-date?

--
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

"FlyGuy" <Fly...@discussions.microsoft.com> wrote in message

news:D731FD36-C009-4CC7...@microsoft.com...

[Gina Whipp]

Another thought...

Does all the other code in your database run and have you Compiled it?
Could be we are so focused on this not seeing that it's actaully preceding
this that is causing the problem.

--
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

"FlyGuy" <Fly...@discussions.microsoft.com> wrote in message

news:D731FD36-C009-4CC7...@microsoft.com...

[FlyGuy]

test post; my last 2 from earlier this AM have not shown up
--
Thanks,

FlyGuy

"Gina Whipp" wrote:

> .
>

[Gina Whipp]

FlyGuy,

You may not see your post but I do... This should help...

http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/8bb06c6b95c1de9b/0b6989d57cce6524?hide_quotes=no

--
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

"FlyGuy" <Fly...@discussions.microsoft.com> wrote in message

news:D6CAEF00-2B64-4003...@microsoft.com...

[vanderghast]

Problem perfectly reproducible here, on Vista (64bits) and Access 2007, but
I have other problems too, probably because of co-existence with Access
2003. Have you, you too, other Access versions on the PC with the problem?
(note that in my case, Access becomes "Not Responsive", here). I don't know
how to solve that problem, though (I am not using Access 2007). Just to
confirm there is a reproducible problem.

Vanderghast, Access MVP

"FlyGuy" <Fly...@discussions.microsoft.com> wrote in message
news:774F16AF-F170-4DA8...@microsoft.com...

[Gina Whipp]

Vanderghast,

THANK YOU... I didn't have the same environment to test. So perhaps this is
a bug. How many of these confirmations do we need to say... HEH, can
someone look at this?

--
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

"vanderghast" <vanderghast@com> wrote in message
news:F54D3F0A-C178-4E8F...@microsoft.com...

[FlyGuy]

I am finally seeing my earlier posts; glad [but sorry] someone else can
reproduce this.

I only have full version of Access 2007, but I do have Access 2002 runtime
and Access 2007 runtime installed.

I'm guessing this is a security bug related to recently installing a new
(I'm developing still) Access 2007 app which will be distributed with latest
Runtime.

I packaged it 1 week ago and installed on my PC for a test.

I already had Access 2007 runtime installed, so installer went past that step.

The app works perfectly when run as accdb, accde, or accdr (packaged or not).

Otherwise, all code works perfectly in all my apps; and all has been
compiled OK.
--
Thanks,

FlyGuy

"Gina Whipp" wrote:

> .
>

[FlyGuy]

Microsift today released an important update for IE 8 on Vista; I just
installed it; unfortunately, it did not fix the issue here.

.aspx links still crash (non responding until touch UI) Access.
--
Thanks,

FlyGuy

[Gina Whipp]

Okay, well... I'm looking around for some help so hang in there!

--
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

"FlyGuy" <Fly...@discussions.microsoft.com> wrote in message
news:7639A650-4296-4964...@microsoft.com...

[Gina Whipp]

FlyGuy,

I believe you have found a bug and it would really help if you could send me
a stripped down of your database. Here's hoping you're still watching this
thread!

--
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

"FlyGuy" <Fly...@discussions.microsoft.com> wrote in message

news:7639A650-4296-4964...@microsoft.com...

[FlyGuy]

Gina, I am still following thread.

Do not know what you mean by "stripped down DB"?

However, the issue (bug) is unrelated to any specific DB file; i can create
a new, 1 form, 1 button DB and immediately reproduce the Access 2007 crash.

All one has to do is try and use any link (using any method) from within
Access that targets an ASPX URL.

Please let me know.

Personally, I believe this is a break [or lock down] caused by a recent
Microsoft security update.

Accessing ASPX URLs used to work perfectly until very recently.

If necessary, I can provide a sample Access 2007 DB that demonstrates the
issue.

Please advise.

Thanks.

Bob
--
Thanks,

FlyGuy

"Gina Whipp" wrote:

> .
>

[Gina Whipp]

FlyGuy,

Since it doesn't happen on my machine I want to be sure I get a database
that exhibits the issue to submit. You can get my eMail address from my web
site http://www.regina-whipp.com I don't post it here because I really
don't want the spam.

--
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
"FlyGuy" <Fly...@discussions.microsoft.com> wrote in message

news:3413892D-0F2B-4A0E...@microsoft.com...