Solved

WebBrowser Control in MS Access stopped working on a 64-bit system

Posted on 2016-10-26
11
37 Views
Last Modified: 2016-11-22
Hi everyone,

for past two years I am using an MS Access app with WebAccess control, showing me an application with a map with some locations - I'm using MS Access 2013 64-bit which wokrs perfectly on 32-bit machine (picture 1) but not on 64-bit, giving me blue screen instead (pic 2).
The same map works on ie (v.11). On a TabCtrl page with WebBrowser control I have a button "Open in external window" (seen on top right corner in Picure 2) which opens ie and correctly displays a map with locations (as shown on Picture 1).

If anyone has the idea, I would appreciate it.
ie11-map-working-on-64-and-32-bit.PNG
WebBrowserControl-on-64-bit.png
0
Comment
Question by:Vedran Vuinac
  • 6
  • 5
11 Comments
 
LVL 57
ID: 41860321
<<I'm using MS Access 2013 64-bit which wokrs perfectly on 32-bit machine (picture 1) but not on 64-bit, giving me blue screen instead (pic 2).>>

 A 64 bit edition of Office can't work on a 32 bit OS.

What's critical here is the way Office is running (32 or 64), both of which can run on a 64 bit OS (and obviously a 32bit edition is the only one that would work on a 32 bit OS).

You may also have a single DB that can run under both, but some things fail when moving to 64 bit Office (like controls).

If your running the DB under 64 bit Office, then everything needs to be 64 bit.  

Jim.
0
 
LVL 57
ID: 41860328
I forgot to ask the question; what version of Office are you running when it does not work?

Jim.
0
 

Author Comment

by:Vedran Vuinac
ID: 41860338
It's Office 2013 64 bit. I am reading about compatibility between 32 and 64 bit Office (2010):
https://msdn.microsoft.com/en-us/library/office/ee691831(v=office.14).aspx

"Native 64-bit processes in Office 2010 cannot load 32-bit binaries. This includes the common controls of MSComCtl (TabStrip, Toolbar, StatusBar, ProgressBar, TreeView, ListViews, ImageList, Slider, ImageComboBox) and the controls of MSComCt2 (Animation, UpDown, MonthView, DateTimePicker, FlatScrollBar).These controls were installed by previous versions of Microsoft Office and are installed by 32-bit Office 2010. An alternative must be found for existing Microsoft Office VBA solutions that utilize these controls when the code is migrated to 64-bit Office 2010. 64-bit Office 2010 does not provide 64-bit versions of the Common Controls."

Ma WebBrowser control is placed in a tabControl page.
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 41860350
<<"Native 64-bit processes in Office 2010 cannot load 32-bit binaries. >>

 Yes, that's it.

 If your are running under 64 bit Office, then you need to either:

1. not use the control
2. find a replacement as there is no 64 bit Web control from Microsoft (and I am not aware of any 3rd party controls either).
3. Not use Office 64 bit edition.

On the last, many switch back to Office 32 bit because of this.   There are a multitude of things that are not yet available for 64 bit (controls, ODBC drivers, etc).

 Microsoft still recommends 32 bit Office unless you need 64 bit specifically.  The only reason for needing it is:

1. Very large spreadsheets in Excel
2. Very large projects in MS Project
3. Very large projects in Visio.

Other then that, the two are identical in features.

This is the route I would go if at all possible.

Jim.
0
 

Author Closing Comment

by:Vedran Vuinac
ID: 41860374
Thanks. I'll talk to our IT support about this.
0
Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

 

Author Comment

by:Vedran Vuinac
ID: 41861790
Now I have Office 2013 32-bit (Professional Plus 2013) on a 64-bit OS, and WebBrowser control is still not working.
The only difference with the computer where WebBrowser control is working is OS which there is 32-bit.
0
 
LVL 57
ID: 41862528
No reason why it should not work....you getting the same result as what you originally posted, or just a blank screen now?

Jim.
0
 

Author Comment

by:Vedran Vuinac
ID: 41877375
Same blue screen.
I do not know where to go from here - there is some kinf of workaround - I simply put the cmdButton which opens Internet Explorer in a new window, so it doesn't use WebBrowser Control. It's not the same, but at least I have this feature.


Nut don't now why WebBrowser control doesn't work for me. Could be some restriction in security (thinking aloud).
0
 
LVL 57
ID: 41877406
<<Nut don't now why WebBrowser control doesn't work for me. Could be some restriction in security (thinking aloud).>>

Quite possible.   Let's see if we can pin it down.

1. Make a new DB.
2. Put in a single form with the web browser control.
3. See if you get the same blue screen.
4. Then post it and I'll see if I get the same result here.

Jim.
0
 

Author Comment

by:Vedran Vuinac
ID: 41897549
Yes it does work on a blank database/new form/add new WebBrowserControl.
0
 
LVL 57
ID: 41897609
<<Yes it does work on a blank database/new form/add new WebBrowserControl.>>

 OK, so the install works.

 Now import that form into your existing app, does it still work?  I suspect it should.

 Next make a copy of the form that had the problem, then delete and re-create the active X control on the form.  Does it work?

 If so, the form was corrupt in some way.

Jim.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

#Citrix #Internet Explorer #Enterprise Mode #IE 11 #IE 8
SSL stands for “Secure Sockets Layer” and an SSL certificate is a critical component to keeping your website safe, secured, and compliant. Any ecommerce website must have an SSL certificate to ensure the safe handling of sensitive information like…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now