Solved

Can Access 32 bit run on Access 64 bit?

Posted on 2013-06-20
3
439 Views
Last Modified: 2013-06-24
I know nothing about this so please bear with me.

I have an Access database which is 32 bit.  But we're trying to run it on a computer with Access 64 bit but when we launch the program nothing is there.

Is there a solution?
0
Comment
Question by:SteveL13
3 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 39262581
Steve,

 Yes, it will run, but it may need some conversion work if it uses any windows API calls or 3rd party controls.

 If it does not (it's plain old Access), then it will run fine.  Differences then are related to the change in Access version itself rather then running it in 32 or 64 bit Office.

 Jim.
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 39262604
What version of Access were you using before going to 2010 (x64)?

If prior to 2007, then what you may be encountering is the Office Macro Security issue.  In 2007, Access implemented a security measure that prevents Access databases from running properly if you have macro security enabled.  If that is the case, you will generally see a Access Security Warning message (along with an Options button) below the ribbon.

If this is your situation, click the Options button, then the Enable radio button, then OK.

You might also want to consider putting the application in a "Trusted Location" or designating the folder that the application is already in as a Trusted Location.
0
 
LVL 11

Expert Comment

by:datAdrenaline
ID: 39271831
Also note that an ACCDE created with Access 32bit will not run through Access 64bit, and vice-versa.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Error when attempting to use Replace function in Access 2010 sql query 4 18
Run SQL Server Proc from Access 11 28
backup programme - VBA 3 24
Help with DoEvents 8 25
This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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.

786 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