Stuart McLachlan
stuart at lexacorp.com.pg
Wed Jan 21 15:58:25 CST 2015
True. It's total address space rather than row/column count that matters. From a couple of different MS pages: "64-bit Office doesn´t impose hard limits on file size. Instead, workbook size is limited only by available memory and system resources. On the other hand, 32-bit Office is limited to 2 gigabytes (GB) of virtual address space, shared by Excel, the workbook, and add-ins that run in the same process. (Worksheets smaller than 2 GB on disk might still contain enough data to occupy 2 GB or more of addressable memory.)" and "A data model´s share of the address space might run up to 500 - 700 megabytes (MB)" -- Stuart On 21 Jan 2015 at 16:41, Bill Benson wrote: > I wouldn't use > 1 million rows as a reason either since Excel has > these limits regardless of 32 bit or 64 bit. > > Rows: 1,048,576 > > Columns: 16,384 > > On Wed, Jan 21, 2015 at 12:35 PM, Gary Kjos <garykjos at gmail.com> > wrote: > > > I have no experience with 64 bit Access. My only exposure to it was > > that it was mistakenly installed on my new 64 bit Windows 7 machine > > at work and after I realized it was 64 bit Office I immediately had > > the machine reimaged with a fresh copy of 64 bit Windows and loaded > > with 32 bit Office and things have been working smoothly since. > > > > As Charlotte said, Microsoft themselves recommends you not use 64 > > bit Office unless you absolutely have to have some feature only > > available there such as spreadsheets larger than 1 million rows. > > > > Sorry can't help you with this one. Good luck with it. > > > > GK