Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2016-10-26
11
Medium Priority
?
139 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 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Following on from our article on "The Murky World of Consent and opt in", we thought we would issue some helpful guidance, not only on consent itself but knowing what information you are capturing, what you are doing with this data and how you can p…
How to create a custom search shortcut to site-search Experts Exchange using Google in the Firefox browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site. Launch your Bookmark Menu: Press 'Ctrl +…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

810 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