Results 1 to 5 of 5
  1. #1
    tagteam is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    501

    Moving to 64bit access

    I am moving to access 64bit. I have already updated my VBA Declare statements to use PtrSafe. I noticed that I also use Long in several places. After updating PtrSafe I tested my 32 bit DB in 64 and it worked fine.




    My question is should I still try to update all of my Long to LongPtr?

  2. #2
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    No. However you do need to convert all handles/ pointers to LongPtr and you may need to convert the API output to LongPtr in some cases.

    If you look on my website I have a series of 5 articles on 32 to 64-bit conversion. The first article has links to two utilities that will help ensure the conversions are correct.
    I can’t give the article URL as I’m answering on my phone but the site link is in my signature line below.
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  3. #3
    tagteam is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    501
    Thanks for the info and reference to your website. I have checked it out and read over the pages. My databases are pretty simple, I don't really know what a handle/pointer is really. The only place I use Long is for variable declaration:
    Dim CustomerID As Long
    CustomerID = Me.CustomerID

    Stuff like that. Is that a handler/pointer or just a declared variable?

  4. #4
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,933
    Hwnd is a pointer to a form window- that needs to be a longptr

  5. #5
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    I was referring to converting pointers in API declarations and type statements
    Hwnd is one such example but there are many more
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

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

Similar Threads

  1. access 64bit problem i think
    By sdel_nevo in forum Programming
    Replies: 7
    Last Post: 11-28-2016, 06:17 AM
  2. Replies: 0
    Last Post: 09-10-2016, 11:55 AM
  3. Replies: 3
    Last Post: 05-03-2013, 12:57 AM
  4. Replies: 2
    Last Post: 10-26-2012, 01:18 PM
  5. Replies: 1
    Last Post: 04-08-2011, 08:06 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