Hyperlink value crashes Access

F

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

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 said:
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 said:
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?

.
 
F

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 said:
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 said:
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?


.
 
G

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 said:
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 said:
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 said:
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?


.
 
F

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 said:
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 said:
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 said:
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?


.
 
F

FlyGuy

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

FlyGuy


FlyGuy said:
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 said:
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 said:
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

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


.
 
G

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 said:
I even get crash after navigating to
http://support.microsoft.com/Default.aspx
--
Thanks,

FlyGuy


FlyGuy said:
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 said:
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


:

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

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


.
 
F

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

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


.


.
 
F

FlyGuy

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

FlyGuy


Gina Whipp said:
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 said:
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 said:
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

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


.


.
 
F

FlyGuy

Access 2007 databases that exhibit issue are in trusted locations.

Macro settings are disable all with notification.


--
Thanks,

FlyGuy


Gina Whipp said:
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 said:
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 said:
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

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


.


.
 
G

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 said:
Access 2007 databases that exhibit issue are in trusted locations.

Macro settings are disable all with notification.


--
Thanks,

FlyGuy


Gina Whipp said:
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 said:
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


:

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

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


.


.
 
F

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 said:
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 said:
Access 2007 databases that exhibit issue are in trusted locations.

Macro settings are disable all with notification.


--
Thanks,

FlyGuy


Gina Whipp said:
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

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


:

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

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


.



.


.
 
F

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 said:
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 said:
Access 2007 databases that exhibit issue are in trusted locations.

Macro settings are disable all with notification.


--
Thanks,

FlyGuy


Gina Whipp said:
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

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


:

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

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


.



.


.
 
G

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 said:
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 said:
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 said:
Access 2007 databases that exhibit issue are in trusted locations.

Macro settings are disable all with notification.


--
Thanks,

FlyGuy


:

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

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


:

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

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


.



.


.
 
G

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 said:
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 said:
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 said:
Access 2007 databases that exhibit issue are in trusted locations.

Macro settings are disable all with notification.


--
Thanks,

FlyGuy


:

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

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


:

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

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


.



.


.
 
F

FlyGuy

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

FlyGuy


Gina Whipp said:
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 said:
Access 2007 databases that exhibit issue are in trusted locations.

Macro settings are disable all with notification.


--
Thanks,

FlyGuy


Gina Whipp said:
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

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


:

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

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


.



.


.
 
G

Gina Whipp

FlyGuy,

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

http://groups.google.com/group/micr...06c6b95c1de9b/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 said:
test post; my last 2 from earlier this AM have not shown up
--
Thanks,

FlyGuy


Gina Whipp said:
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 said:
Access 2007 databases that exhibit issue are in trusted locations.

Macro settings are disable all with notification.


--
Thanks,

FlyGuy


:

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

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


:

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

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


.



.


.
 
V

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
 

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