64 bit Vista Ultimate with 4 Gb

[Gary G. Little]

It would seem that Access 2007 is actually slower on a Duo core laptop with
the subject configuration, than 32bit Vista Ultimate. Has anyone seen this
and found a work around or solution? Case inpoint: I work with a team that
uses Access 2007 on both 32 bit Vista and 64 bit Vista. On a given 32 bit
system with 2 gig of RAM an analysis report takes about 6 minutes to
complete. On my 64bit machine the same report takes over 15 minutes to
complete. I highly suspect that the issue is the amount of THUNKING taking
place in Access and the OS which really tells me that Access may not be a
64 bit app.

Aside from the tuning mentioned in the documentation, which I have done, is
there a resonable way to get a more reasonable responce from a 64bit OS and
laptop?

Gary

 

[Arvin Meyer [MVP]]

Microsoft Office is a 32 bit application suite which can run (with possible
limitations) on a 64 bit Vista system.

http://office.microsoft.com/en-us/products/HA101668651033.aspx

 

[david]

Reports often take a long time to run because they are Sorting,
or getting data from Disk, or Rendering. Or because you are
running Anti-Virus software. Can you work out which process
is slow?

(david)

 

[a a r o n _ k e m p f]

Access is not a 64 bit app.. unless you use Access Data Projects
(which definitely support 64 bits on the backend)

 

[a a r o n _ k e m p f]

I'd reccomend moving to SQL Server, Jet is slow and retarded.. it has
been obsolete for a decade