+ Reply to Thread
Results 1 to 5 of 5

Making an old 2000 database file work with 365

  1. #1
    Registered User
    Join Date
    05-01-2012
    Location
    Guildford, England
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    82

    Making an old 2000 database file work with 365

    Dear All,
    I have inherited an old database/program that was made back in the day of 2000'ish. I need to try make it work in todays 365 world.
    Looking online I found info about changing (Long) to (LongPtr) when Long is in parenthesis and also PTRSafe

    Having tried changing all the (Long)s I can find but to no avail.
    File is company confidential so I cannot put it up here.

    Anyone have any other suggestions? I appreciate without the file/program this is probably a big ask.......but hey, no harm asking for suggestions.
    Thanks in advance.......Steve

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    7,221

    Re: Making an old 2000 database file work with 365

    If it's access database you can open it and save it as a new format.
    What you mention about PtrSafe and so means that it contains macros as well.
    PtrSafe should be set only it it's 64-bit

    and you only set the public or private references, you DO NOT change ALL the Longs,
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    05-01-2012
    Location
    Guildford, England
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    82

    Re: Making an old 2000 database file work with 365

    Thanks for the reply. Firstly let me say that I have a VERY limited understanding of code and my knowledge goes nowhere near this problem!

    As I understood it from internet searches, (Long) in parenthesis you change to LongPTR.......and those not in parenthesis you leave alone.
    The declare function (which shows in red when I open the file) has to have the PtrSafe inserted so Declare Function becomes Declare PTRSafe Function

    The are like 30/40 code windows that open up which I guess I will have to look thru and change

    HTML Code: 
    and you only set the public or private references, you DO NOT change ALL the Longs,
    By public or private do you mean the stuff inside ()'s where it says Public Function or Private Funtion?
    Example
    HTML Code: 
    Public Function PipeDesc2(lPID As Long) As String


    Please Login or Register  to view this content.
    What 'Long' changes do you make when it is this:
    Please Login or Register  to view this content.
    changes
    Last edited by ndtsteve; 11-21-2021 at 07:30 PM.

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    7,221

    Re: Making an old 2000 database file work with 365

    This the way to handle 64-bit compatibility:

    Please Login or Register  to view this content.
    The LongPtr is not always necessary, just the Declare lines with a Long as result, Maybe consider Declaring Prublic

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    6,590

    Re: Making an old 2000 database file work with 365

    The changes are nothing to do with scope. If the variable is a pointer or window handle, it should be a LongPtr. You should really read this before mucking about with API calls, especially if you are not a coder: https://jkp-ads.com/Articles/apideclarations.asp
    Rory
    I drink, and I know things

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. excel file to work as a database for storing pdf files
    By santbiju1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2015, 03:52 PM
  2. excel file to work as a database for storing pdf files
    By santbiju1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-02-2015, 10:17 AM
  3. excel file to work as a database for storing pdf files
    By santbiju1 in forum Excel General
    Replies: 0
    Last Post: 07-02-2015, 09:53 AM
  4. how to attach pdf in excel file and work as database
    By santbiju1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-02-2015, 09:45 AM
  5. Replies: 5
    Last Post: 11-13-2014, 11:15 AM
  6. Hyperlinks in Excel database don't work when file is reopened.
    By Anne Tarctica in forum Excel General
    Replies: 0
    Last Post: 05-07-2006, 12:10 PM
  7. Replies: 1
    Last Post: 05-05-2005, 06:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1