64 bit Issue...?

[gblack]

I am getting a new laptop at work. The old Laptop has MS Access 2007 and the new Laptop has a 64 bit version of MS Access 2010.

I have copied many of my MS Access files over (i.e. accdb files). The issue is that I cannot seem to open any of them. Every time I do I get an error message saying "Unrecognized Database Format:..."

The reason I think this conflict could be a 64 vs 32 bit issue is for this reason: in a previous job I was running a split database application (Office 2007), in a multi-user setting, and had the very same issue when I had the 64 bit version of MS Access 2010 installed on my machine... so they uninstalled the 64 bit versionand give me the 32 bit version of 2010 and my application ran fine. Unfortunately I don't have that option here... I am pretty much stuck with what I have.

So does it make any sense that I am not able to open a 32 bit file with the later version of MS Access? If so, is there anything I can do about this?

Just FYI: I also tried to open a new file and import the objects from the old file into a new one, but I still get the same error when I try that. For some reason it just doesn't understand what the old .accdb file is.

Any help on this would be greatly appreciated!
-Gary

 

[pr2-eugin]

Hello Gary, I had the problem when some of my front end systems had Access 64 bit and I had 32, so I did my development in 32 bit and used the following code to be compatible on 64.. but not sure if it will solve your problem..

#If Win64 Then
    'Declare PtrSafe Function FunctionName Lib "kernel32" () As LongLong
    Private Declare PtrSafe Function LoadLibrary Lib "kernel32" _
    Alias "LoadLibraryA" (ByVal lpLibFileName As String) As LongLong
    
    Private Declare PtrSafe Function FreeLibrary Lib "kernel32" _
    (ByVal hLibModule As Long) As LongLong
    
    Private Declare PtrSafe Function GetCurrentThreadId Lib "kernel32" () As LongLong
#Else
    'Declare PtrSafe Function FunctionName Lib "kernel32" () As Long
    Private Declare PtrSafe Function LoadLibrary Lib "kernel32" _
    Alias "LoadLibraryA" (ByVal lpLibFileName As String) As Long
    
    Private Declare PtrSafe Function FreeLibrary Lib "kernel32" _
    (ByVal hLibModule As Long) As Long
    
    Private Declare PtrSafe Function GetCurrentThreadId Lib "kernel32" () As Long
#End If

Can you at least import if so, try to add the code before import.. If you cannot import anything at all? Have you tried exporting to Text and importing the Text file back??