?
Solved

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

Posted on 2016-10-26
11
Medium Priority
?
102 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

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…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
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

743 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