Results 1 to 4 of 4
  1. #1
    RayMilhon is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,071

    Access 2010 API problem

    I need some help. I have an Access 2010 Database that uses the kernel32.dll and advapi32.dll for 2 specific functions. On my machine the DB works without issues. When installed on any of the user's PC's I'm getting an error that the OS is 64 bit and the DLL are 32 bit and need to be upgraded. The weird part is My system is also 64 bit and I don't get that error. I have no idea what the difference is between my machine and theirs any help is appreciated.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    I have gotten this too. Certain PCs cause trouble. Try this, double your calls to the api by doing a check first and use an enhanced 64 bit declare....

    Code:
    
    #If Win64 Then
        Private Declare PtrSafe Function GetDesktopWindow Lib "user32" () As Long
    #Else
         Private Declare Function GetDesktopWindow Lib "user32" () As Long
    #End If

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    My vote is Ranman's answer.

  4. #4
    RayMilhon is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,071
    It was Ranman's answer that worked perfectly. Thanks

Please reply to this thread with any new information or opinions.

Similar Threads

  1. One more problem (for now) with Access 2010
    By NISMOJim in forum Forms
    Replies: 5
    Last Post: 12-21-2013, 06:03 PM
  2. Another Access 2010 problem
    By NISMOJim in forum Programming
    Replies: 10
    Last Post: 12-20-2013, 06:52 PM
  3. VBA SQL in Access 2010 problem
    By ruthib4 in forum Programming
    Replies: 1
    Last Post: 03-13-2012, 09:08 AM
  4. Replies: 6
    Last Post: 02-18-2012, 07:20 AM
  5. Access 2010 Problem
    By DSTR3 in forum Access
    Replies: 7
    Last Post: 11-29-2010, 05:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums