Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2016-10-26
11
Medium Priority
?
121 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 58
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 58
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 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
 

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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

636 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