Improve company productivity with a Business Account.Sign Up

x
?
Solved

ODBC error when opening 32 bit query on 64 bit office

Posted on 2013-10-23
2
Medium Priority
?
1,363 Views
Last Modified: 2013-10-23
Hi all,

We've just made a massive leap from office 2003 (32bit) to Office 2013 (64bit). Of course we have lots of problems now. One problem is that users are now getting an error when trying to open existing query files (.dqy file) that were created in excel 2003. It would appear that we can create new ones, but not edit existing.

I have tried installing the access runtime 64 bit but this doesn't work.

Anyway of getting round this?
0
Comment
Question by:MJB2011
  • 2
2 Comments
 
LVL 59

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 39593897
<<We've just made a massive leap from office 2003 (32bit) to Office 2013 (64bit).>>

 Well hate to be the bearer of bad news, but that probably was a mistake.   You should if at all possible stick with 32 bit Office.

<<One problem is that users are now getting an error when trying to open existing query files (.dqy file) that were created in excel 2003. It would appear that we can create new ones, but not edit existing. >>

 The problem is in general, everything you had was 32 bit and now needs to be 64.  That means:

1.  DSN's need to be created in the right place if you use them (there is an ODBC32adm.exe for 32 bit and one for 64 bit).
2. All drivers need to be 64 bit (ie. ODBC)
3. Calls to certain Windows API's will need have the PtrSafe attribute added.
4. Some Window API calls will need to be changed as they are different between 32 and 64 bit.
5. Any 3rd party DLL's, componets, etc will need to be changed.

On the flip side, the only thing 64 bit Office gives you is extremely large spreadsheets in Excel.   If you don't need that, then run, don't walk to 32 bit Office.

 Even Microsoft still recommends 32 bit Office.

Jim.
0
 
LVL 59
ID: 39593906
And just to be clear on this:

"Well hate to be the bearer of bad news, but that probably was a mistake.   You should if at all possible stick with 32 bit Office."

  32 bit Office or 64 bit Office will run under a 64 bit OS.   Just because the OS is 64 bit does not mean you need to run 64 bit Office.

 Also be aware that you cannot mix products within Office.  All either need to be 32 bit or 64 bit.   For example, you can't install Excel in 64 bit and Access in 32 bit.

Jim.
0

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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.

Join & Write a Comment

This article presents several of my favorite code snippets.
With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

588 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