Upgrading to Access 2007

[tacos]

We are considering upgrading from Access 97 to Access 2007. Some have
mentioned that Access 2000 and 2003 are not as stable as Access 97. They
also say that it uses more resources and thus it may be hard to multitask.
Does anyone have good information about Access 2007 (Pros and Cons)? I have
been looking on the Microsoft website but I can't seem to find any worth
while information. If anyone has some good information I would appreciate
it. Thank you

 

[Douglas J. Steele]

Check what Allen Browne has at http://www.allenbrowne.com/Access2007.html
and what Jeff Conrad has at http://accessjunkie.com/default.aspx

 

[Tony Toews [MVP]]

We are considering upgrading from Access 97 to Access 2007. Some have
mentioned that Access 2000 and 2003 are not as stable as Access 97. They
also say that it uses more resources and thus it may be hard to multitask.

With the patches A2000 was quite stable. A2003 certainly is stable.
In my opinion every bit as good as A97.

Does anyone have good information about Access 2007 (Pros and Cons)?

It is a radical change however A2007 also seems relatively stable. It
does have just a few quirks of course.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[James A. Fortune]

We are considering upgrading from Access 97 to Access 2007. Some have
mentioned that Access 2000 and 2003 are not as stable as Access 97. They
also say that it uses more resources and thus it may be hard to multitask.
Does anyone have good information about Access 2007 (Pros and Cons)? I have
been looking on the Microsoft website but I can't seem to find any worth
while information. If anyone has some good information I would appreciate
it. Thank you

I think that for computationally intensive tasks A2K7 might be able to
take advantage of .NET's (current and potential) ability to utilize
available multi-core processing in a way that previous versions cannot.
The idea is to have .NET code that runs in A2K7 programmed in such a
way that it utilizes the currently available multi-core capability and
if the number of cores available increases, it uses those too.

This idea came from:

PDC05 FUN323 - Microsoft Research: Future Possibilities

Tim Harris

Learn about the investment Microsoft Research is making in future
languages and tools to help write software that will gain the maximum
benefit from tomorrow's multi-processor/multi-core hardware. In this
session, we start by introducing some of the tools and techniques we've
developed for tracking down and preventing bugs in multi-threaded
software. We then turn to the language features that we're prototyping
in research: our work on transactional memory is developing a
programming model where data can be shared directly between threads
without needing to worry about locking or low-level deadlocks; our work
on synchronization is leading to a unified abstraction for co-ordination
between threads and between processes. We'll demo some of our prototype
systems, showing how these techniques can lead to software which is not
only easier to develop, but which can scale from uniprocessors up to
highly parallel systems.

Let me know if you need me to track down some links given in that
presentation.

James A. Fortune
(e-mail address removed)