Solved

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

Posted on 2016-10-26
11
84 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 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
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 
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
 

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

To Patch or not to Patch? That is the question!

Don't get caught out like thousands of others around the world in the recent Ransomware Fiasco!
Discuss..
- Why it's not a good idea to wait before Patching
- Sensible approaches to Patching discussed
- Add your feedback, comments and suggestions

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Microsoft Access report help 4 37
Can not open the Access Help ? 3 37
Handle Apostrophes in VBA SQL - Part 2 10 47
Speed up Select Top n... Query 9 36
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 …
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

734 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