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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Old Access file 32 Bit error in 64 Bit Access 2010

Status
Not open for further replies.

Scott24x7

Programmer
Jul 12, 2001
2,826
JP
Hi all,
I have an Access database that was created (I believe, as I "inherited it" I'm not sure when) with Access 2003. I have upgraded some machines to Win7 64bit and Office 2010 64bit, and now it doesn't work. I get a grumbling from the application that "kernal32" is not compatable with 64bit, the exact error I get is:

Compile Error:

The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then mark them with the PtrSafe attribute.

The offending line is always on the "kernal32" line.
Two instances like:
Code:
Private Declare Function GetLocaleInfo _
 Lib "kernel32" _
 Alias "GetLocaleInfoA" _
 (ByVal Locale As Long, ByVal LCType As Long, _
 ByVal lpLCData As String, ByVal cchData As Long) As Long

Private Declare Function GetSystemDefaultLCID _
 Lib "kernel32" () As Long

Is this an "easy fix" to make this run under 64bit machine?

Thanks in advance for any help.

Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."[hammer]
 
Any suggestions? I'm getting no where... :(

Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."[hammer]
 
Sorry to bring this up again. I've still found nothing that works. Are there no VBA devs here?


Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."[hammer]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top