Eljefegeneo
Still trying to learn
- Local time
- Today, 08:16
- Joined
- Jan 10, 2011
- Messages
- 904
I have recently started upgrading the computers at work to all windows 10 and either Office 365 or whatever they call it (Access 2019) from Access 2010. I have 6 different databases and I upgraded all of them.
The only changes that I noticed were the declarations, where the new installations are 64 bit and most of the old code was in 32 bit. A few changes, adding PtrSafe to the declarations and all seems OK. I then reversed it and copied the Access 2019 files back to the computer using Access 2019 and so far all seems OK although I have not run through every form or query.
I have attempted to research the differences and the helpful page I found at:
https://www.fmsinc.com/microsoftaccess/history/features.htm
did not bring up anything I needed to be concerned with.
I did find a reference to the change in the "memo" field which is now called Long Text. But I checked the computer using Access 2019 the tables which had memo fields still have them. They are still called "memo" fields.
So, first of all, do I need to change them to "Long Text" and if so do I risk losing the data by doing this, or can I just leave well enough alone?
Second, is there anything else that comes to mind that I might be concerned with in this change over?
Thanks.
The only changes that I noticed were the declarations, where the new installations are 64 bit and most of the old code was in 32 bit. A few changes, adding PtrSafe to the declarations and all seems OK. I then reversed it and copied the Access 2019 files back to the computer using Access 2019 and so far all seems OK although I have not run through every form or query.
I have attempted to research the differences and the helpful page I found at:
https://www.fmsinc.com/microsoftaccess/history/features.htm
did not bring up anything I needed to be concerned with.
I did find a reference to the change in the "memo" field which is now called Long Text. But I checked the computer using Access 2019 the tables which had memo fields still have them. They are still called "memo" fields.
So, first of all, do I need to change them to "Long Text" and if so do I risk losing the data by doing this, or can I just leave well enough alone?
Second, is there anything else that comes to mind that I might be concerned with in this change over?
Thanks.