troubleshooting Question

How to sort out APIs for 64 BIT Vs APIs 32 BIT

Avatar of Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScFlag for Zambia asked on
Microsoft Access
2 Comments1 Solution6 ViewsLast Modified:
I had had this API issues with Ms Access 32 BIT and 64 BIT for sometime now, whenever we deploy a package we find some computers have 64 bit Office or 32 BIT and users want to maintain their office BIT no matter what it takes. How can we can harmonize the Compiled 32 BIT to work with 64 BIT.

The major issue are APIs for 32 BIT cannot work in 64 BIT

APIs for  32 BIT

'Api declare to find out the current computer name
Public Declare Function GetComputerName Lib "kernel32" Alias _
  "GetComputerNameA" (ByVal lpBuffer As String, nSize As Long) As Long
'Api Declare to find the current User Name
Public Declare Function GetUserName Lib "advapi32.dll" _
  Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long

APIs for 64 BI

Public Declare PtrSafe Function GetComputerName Lib "advapi32.dll" _
    (ByVal lpBuffer As String, nSize As Long) As Long
'Api Declare to find the current User Name


Public Declare PtrSafe Function GetUserName Lib "advapi32.dll" _
    (ByVal lpBuffer As String, nSize As Long) As Long

The problem here to sort out the above we need to have two laptops for Ms Access 32 BIT and 64 BIT which I think is not viable.

Is there solution to this issue


Regards

Chris
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros