Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I open my 32bit app in 64bit office 2010

Status
Not open for further replies.

Jackxxx

Programmer
Jun 21, 2007
31
US
I'm trying to open my Access 2007 database app in office 2010 64bit. I get a message that tells me I need to delete all my code in order to open the app.

Are we required to rewrite all our code to support 64bit Access?
 
What I've found is that 64-bit Access wants the keyword ptrSafe, which 32-bit does not recognize. Here's one way I have been able to maintain one system that works on both versions:

Code:
#If VBA7 And WIN64 Then
        Private Declare PtrSafe Function ....
#Else
        Private Declare Function ....
#End If

Its a real pain and has to be done for every function declare.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top