MS Access accde hangs up on system

I have an MS access 2010 accde that works fine in many clients./  It's a local accde connected to a database on a server drive.  We have many clients and all work fine but one.  This client has installed Office 2016 64-bit without Access but including Word, Excel and PP.  They left Access 2010 on the system.  The Access application locks up frequently.   Could the 64-bit office cause issues with the 32-bit Access application?  Other ideas on how to test the application?
LVL 14
Bill RossAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
<<Thanks to all for your help in "making the case".>>

  No problem.   You'll probably be better off with 32 bit for the next few years (and Kudo's to Dale for suggesting that), but I've gotten the sense lately that Microsoft wants to start pushing 64 bit now.   They've started releasing 64 bit versions of some things here and there, making it easier for folks to make the transition over to 64 bit.

 I'm actually surprised they haven't before now (we've had 64 bit for seven years!), but they have been so focused on the cloud.   I think they've finally realized though that the desktop is not going away anytime soon and they need to spend some time on it.

  Must take a lot of effort on their part to maintain two code bases and there can't be too many 32 bit OS's out there anymore.

Jim.
0
 
John TsioumprisSoftware & Systems EngineerCommented:
I guess the quick and dirty solution is to uninstall everything related to Office
Just Uninstall them via control panel ...and then run the Remover Tool to clean the remnants.
If you want to be on the safe side take a full image of the system.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
In general a 32-bit application will work fine on a 64-bit Office installation (won't work the other way around, of course), and you can install different "bit-ness" Office products as long as they are different versions.

That's not generally a good idea, however. Office and Access share far too many libraries, even among different versions, so the chance of peaceful coexistence is slim.

Only way to test would be to replicate their environment on your system, preferably using virtual machines. You'd need licensing for all those apps, of course, which can get pricey unless you have an MSDN subscription, or the ActionPack subscription.

You'd be much better off suggesting your client use the same version of Office products throughout. The cost of a single Access license is not anywhere close to the hours of consulting time you'd spend trying to troubleshoot this, so just approach them from the standpoint of that - it's cheaper for you to upgrade (plus you should anyway).
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
John TsioumprisSoftware & Systems EngineerCommented:
At least to my knowledge a 32 bit Access won't work on 64bit Access...just yesterday i stumbled on this on a client's machine
Error Access 32 bit on Access 64bitIt's Greek but essential it says that in order to run this Access that was created with Access 32 you need 32bit Access
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
You can run different versions of Office products with different "bit-nesses" - for example, you can run Office 2016 64 bit, but still run Access 2010 32-bit. It's not a good idea, and will cause you no end of grief, but it will work.

You can only have a single version of Outlook on a single machine, but that's the only Office product I know of that has that restriction.
0
 
John TsioumprisSoftware & Systems EngineerCommented:
Well i must admit i haven't done this test...i reckon that as long the 32bit Access is "confined" on its own it would be just fine...i am not sure when you have Automation between 32bit and 64bit...
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Bill,

<<The Access application locks up frequently. >>

 Could you go into this a bit more?   Are you seeing it just hang, or getting errors?

<<This client has installed Office 2016 64-bit without Access but including Word, Excel and PP.  They left Access 2010 on the system. >>

  I think I would have them go the other way; remove Access 2010 and run A2016 even though 64 bit.

  As Scott said, most apps will run fine.   However if you've used any API calls, you'll need to fix those for 64 bit.    Also you will have to distribute an accde compiled with 64 bit since .accde's cannot be recompiled on the fly.

@Scott and John:

  For Access 2010 and 2013, you could not mix 32 and 64 bit versions of Office.   Starting with A2013, many of the libs were shared.    I don't know if A2016 has changed in this regard or not, but I would suspect not.

  As far as I know, it's only with A2007 vs 2010,2013, and 2016 that you can have a different bitness and have everything work correctly.

  Up until A2013, it was always said that you only needed the same bitness within a single major version (ie. A2007 and back could be 32 and A2010 could be 64 without issue), but apparently 2013 used a lot of the same lib names as 2010, and this broke that rule.   To add confusion to everything, Microsoft continued to state that after 2013 came out, but that appears not to be the case.    I'll try and find out if this is really true or not, but from real world problems, that seems to be the case.

   Certainly a mess which ever way you look at it.

Jim.
0
 
Dale FyeCommented:
My recommendation would be for you to uninstall the 64 bit version of office from the one computer and install the 32 bit version instead.  Even Microsoft suggests not to use 64 bit office unless you need Excel's really large number capability.

Dale
1
 
Bill RossAuthor Commented:
Hi All,  Thanks for the comments and the help!

The application hangs during search and data entry several times per day and is very slow compared to other installs at other locations.  Mostly during search.  We've rebuilt the data MDB (not ACCDB) data file on the server and rebuilt and recompiled the application.  We cannot flip the front end accde to AC64 bit since we use FMS Total Access Memo and there is no 64 bit version.

The IT folks steadfastly refused to install 32-bit unless I can assure them 100% that that's the issue.

Thoughts?
0
 
aikimarkCommented:
Time to do some science to prove/disprove the hypothesis
0
 
John TsioumprisConnect With a Mentor Software & Systems EngineerCommented:
I don't think that none here can guarantee that this is the solution but unless you make some steps probably you would never resolve it.
Since IT Folks think about 100% and such ...ask them to make a complete image of the system just to be on the safe side....and because that 100% is not an easy statement ...they should seek for info to resolve this issue not you.....or at least not only you.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
The IT folks steadfastly refused to install 32-bit unless I can assure them 100% that that's the issue.

Well as Dale said, Microsoft itself still recommends 32 bit:

https://support.office.com/en-us/article/choose-between-the-64-bit-or-32-bit-version-of-office-2dee7807-8f95-4d0c-b5fe-6c6f49b8d261

 
 32 bit installs is still the default as with 64 bit, there are very few advantages and a lot of downside.

 as far as the other comments I made, I am checking with others and Microsoft if mixing bitness across versions is really an issue or not.

Jim.
0
 
Bill RossAuthor Commented:
Hi Jim,  Thank you for any help from MS.  This has become a real pain...
0
 
Bill RossAuthor Commented:
Latest update is that IT has agreed to move to 32-bit Office 2016.  Does it make sense to convert the back end MDB to an ACCDB or ACCDE?  Will that provide any benefit?  All the back end has is tables and data.  This app has been in use since AC2000 days.

Thanks for your help!

Bill
0
 
Dale FyeConnect With a Mentor Commented:
Yes, it makes sense to migrate the BE from 2003 (mdb) to an accdb format.

Make sure you get a backup of the mdb file before upgrading the BE to 2016.  You will then have to relink all of the tables to the FE.

Dale
0
 
Bill RossAuthor Commented:
Hi Dale,

I have about 25 sites that I would need to change or I would need to have different FEs for those with accdb and mdb so it will be a major undertaking in time for me.  What is the difference/benefit of ACCDB over MDB for the back end?

Thanks,

Bill
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Does it make sense to convert the back end MDB to an ACCDB or ACCDE?

 It depends.   If your using work group security, then no, not until you can replace the security (the conversion will strip out the security).  If you don't know what I'm talking about, then don't worry about it.

 Also, unless your using some of the newer data types, then there is no difference really.  the ACE database engine is nothing more than JET 4.0 with some tweaks.

 At some point though, you will want to bring it forward.  

Jim.
0
 
Bill RossAuthor Commented:
OK.  I'm going to wait on this as it's working OK everywhere else and max 100k records or so.  Our latest version uses SQL.  We removed access security long ago.  

I'll check back when the users have given it another shot.

Thanks to all for your help in "making the case".

Bill
0
 
Bill RossAuthor Commented:
Hi Jim,  Good point!  Again, thanks to all.  Will close this question once I get feedback from my favorite IT folks.
0
 
Bill RossAuthor Commented:
So - latest is that all works OK after removing 64-bit Office, removing Access 2010 and compacting mdb file.  Seems like the Access 2010 search was trying to use the 64-bit component.  Anyway, thank you all for the help!!!

Bill
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.