Forum Discussion
SQL Server Migration Assistant for Access - Hangs when selecting Access DB
I downloaded Microsoft SQL Server Migration Assistant for Access last week and successfully converted my local Access database to an online MS SQL database. After testing it for a week I decided to d...
Sorry I'm confused by your first sentence.
You can certainly still install 32-bit Windows, Office & SSMA
There are many good reasons for running 64-bit Windows.
However, there are very few advantages in running 64-bit Office but many issues with doing so e.g. API declarations need converting. some reference libraries & ActiveX controls don't work....
You can certainly still install 32-bit Windows, Office & SSMA
There are many good reasons for running 64-bit Windows.
However, there are very few advantages in running 64-bit Office but many issues with doing so e.g. API declarations need converting. some reference libraries & ActiveX controls don't work....
OK, I didn't know they even still made a 32-bit version of Windows. Must be for special situations.
I know there are a few considerations with 64-bit Office and you have to make some changes, like adding PtrSafe to API declarations and so on because Microsoft didn't properly deprecate their code, but it can give you more room for memory and larger capacity for data, which should be a good thing to make faster and more robust applications.
You know down the road at some point they're going to phase out 32-bit support overall. May as well be ready.
I know there are a few considerations with 64-bit Office and you have to make some changes, like adding PtrSafe to API declarations and so on because Microsoft didn't properly deprecate their code, but it can give you more room for memory and larger capacity for data, which should be a good thing to make faster and more robust applications.
You know down the road at some point they're going to phase out 32-bit support overall. May as well be ready.
- Windows is still available in 32-bit and AFAIK is still widely used though gradually declining in favour of 64-bit which has better memory management etc. Its certainly not for 'special situations'.
Using 64-bit Office does not allow a larger capacity for data with the exception of Excel. However it could be argued that any Excel file that is too large for 32-bit should probably be a database in Access anyway.
The ONLY advantage of 64-bit Access that
I have ever noticed is large address awareness which can allow certain lengthy operations to be performed faster. However LAA is also coming to 32-bit A365 in a few months time!
So I certainly wouldn't be strongly encouraging anyone to convert to 64-bit Office until a time that suits them.
However, as a commercial Access developer, I've been using 64-bit and 32-bit Office for about 9 years and all my commercial apps are designed to work in both. I agree that eventually MS will probably phase out 32-bit software but don't expect that will be for several more years yet
