Access 2016 Application to Access 365 - Will It Work?

[CJ_London]

think it is more to do with performance - a 1m row excel file should be much faster in 64bit



found this MS article -

https://support.microsoft.com/en-us/...e-6c6f49b8d261

[isladogs]

I think this relates back, at least in part, to my comments about large address awareness (LAA) in post #7.
Although not yet natively available in 32-bit Access, Philipp Stiefel has code you can use to add this now The /LARGEADDRESSAWARE (LAA) flag - Remedy for out-of-memory errors - Codekabinett
In my tests, using LAA significantly helped both with performance and memory issues