473,725 Members | 2,053 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Biting the upgrade bullet -- which version of Access is leastproblemati c/buggy?

Don
I've continued to use Access 97 all these years because (1) it does
everything I need quickly and (2) most of what I've read online
indicates that it's still the most bug-free version of Access. But
now that Vista is gradually becoming the only Windows choice and Vista
doesn't exactly "cooperate" with Access 97, I'm afraid it may be time
to take the leap.

I haven't had any experience with later versions of Access so I'm
seeking recommendations .

* Which version of Access is the most stable/bug-free? 2000? 2002?
2003? I really need the Replication/synchronization feature so that
may rule out Access 2007.

* Depending on the version I upgrade to, is there a good soure (onlne
or otherwise) that helps with the transition and learning about the
new features? I have some pretty involved projects with lots of VBA.

Many thanks for any & all suggestions & input...

--Don
Aug 29 '08 #1
9 2770
I'd recommend upgrading to Access 2003. It's the most stable/bug free
version since Access 97 sr2. You need to set the macro security on low to
avoid the big brother attempts to keep you from making the sky fall whenever
you open any db.

Most online tutorials are geared for Access 2007, since that's the most
recent release. Microsoft has some online tutorials on Access 2003 for you,
but they aren't going to be the "what's new" and "what's different from
Access 97" you want:

http://office.microsoft.com/en-us/tr...829401033.aspx

http://office.microsoft.com/en-us/ac...CL100570041033
Chris
Microsoft MVP
Don wrote:
>I've continued to use Access 97 all these years because (1) it does
everything I need quickly and (2) most of what I've read online
indicates that it's still the most bug-free version of Access. But
now that Vista is gradually becoming the only Windows choice and Vista
doesn't exactly "cooperate" with Access 97, I'm afraid it may be time
to take the leap.

I haven't had any experience with later versions of Access so I'm
seeking recommendations .

* Which version of Access is the most stable/bug-free? 2000? 2002?
2003? I really need the Replication/synchronization feature so that
may rule out Access 2007.

* Depending on the version I upgrade to, is there a good soure (onlne
or otherwise) that helps with the transition and learning about the
new features? I have some pretty involved projects with lots of VBA.
--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200808/1

Aug 30 '08 #2
The most stable version is the one running a well-designed and
carefully-crafted application.
Aug 30 '08 #3
Don <do******@gmail .comwrote:
>* Which version of Access is the most stable/bug-free? 2000? 2002?
2003?
A2003 fully patched. A2007 is still a bit new even with SP1 to be completely bug
free yet.
>I really need the Replication/synchronization feature so that
may rule out Access 2007.
I think that is still available if the BE is in MDB format. But not in ACCDB format.
>* Depending on the version I upgrade to, is there a good soure (onlne
or otherwise) that helps with the transition and learning about the
new features? I have some pretty involved projects with lots of VBA.
I'd have to think back a bit as to the problems. Nothing major. I suspect Allen
Browne may have a page on this topic at www.allenbrowne.com.

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/
Aug 30 '08 #4
I think you'll be pleasantly surprised by Access 2003. It's really not much
more than Access 97 with a paint job, and so it'll all seem very familiar to
you. Sure there are new bells and whistles for you to learn about, but no
fundamental differences. Even the Help system approaches useful, unlike the
dross that we got in 2000 and 2002 (and, sadly, 2007).

I doubt that you'll find a list anywhere of what's new in Access 2003
compared to 97 (there were two versions in between!) so you might have to
Google through the versions in turn (2000, 2002, 2003) to get a full picture
of all the new toys you have to play with.

Googling "what's new in Access <version>" should get you lots of
information.
"Don" <do******@gmail .comwrote in message
news:5f******** *************** ***********@b1g 2000hsg.googleg roups.com...
I've continued to use Access 97 all these years because (1) it does
everything I need quickly and (2) most of what I've read online
indicates that it's still the most bug-free version of Access. But
now that Vista is gradually becoming the only Windows choice and Vista
doesn't exactly "cooperate" with Access 97, I'm afraid it may be time
to take the leap.

I haven't had any experience with later versions of Access so I'm
seeking recommendations .

* Which version of Access is the most stable/bug-free? 2000? 2002?
2003? I really need the Replication/synchronization feature so that
may rule out Access 2007.

* Depending on the version I upgrade to, is there a good soure (onlne
or otherwise) that helps with the transition and learning about the
new features? I have some pretty involved projects with lots of VBA.

Many thanks for any & all suggestions & input...

--Don

Aug 30 '08 #5
Typically Access 2003 uses JET 4, while Access 97 uses JET 3.5.
JET 4 has many new and powerful capabilities.

IMO, these new capabilities were largely ignored by the Access
community, including the Access MVP community.

Pity!

On Aug 30, 5:54*am, "bcap" <b...@nospam.no wherewrote:
I think you'll be pleasantly surprised by Access 2003. *It's really notmuch
more than Access 97 with a paint job, and so it'll all seem very familiarto
you. *Sure there are new bells and whistles for you to learn about, butno
fundamental differences
Aug 30 '08 #6
Version 2003, hands down! Tried and proved. It does, indeed, have a number of
useful enhancements, but essentially works as previous versions. One of the
most telling statements I've seen about v2007, by someone here (sorry, can't
remember who) is that the learning curve for v2007 is about 3 times as large
for an experienced Access developer as it is for a newbie.

Allen Browne has an excellent article on his site that discusses what needs
to be done when upgrading from v97 to v2000 and beyond:

http://allenbrowne.com/ser-48.html

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200808/1

Aug 30 '08 #7
On Aug 31, 5:08*am, "Linq Adams via AccessMonster.c om" <u28780@uwe>
wrote:
Version 2003, hands down! Tried and proved. It does, indeed, have a number of
useful enhancements, but essentially works as previous versions. One of the
most telling statements I've seen about v2007, by someone here (sorry, can't
remember who) is that the learning curve for v2007 is about 3 times as large
for an experienced Access developer as it is for a newbie.

Allen Browne has an excellent article on his site that discusses what needs
to be done when upgrading from v97 to v2000 and beyond:

http://allenbrowne.com/ser-48.html

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.c omhttp://www.accessmonst er.com/Uwe/Forums.aspx/databases-ms-access/2008...
I find A2007 to be slow. Slow at opening forms, slow at running
queries, slow at everything. It just isn't as responsive as A2003.
The whole of Office 2007 is the same. Excel 2007 is also a slug.
When will MS learn that new bells and whistles shouldn't come at the
expense of speed and productivity?
Aug 30 '08 #8
Don <do******@gmail .comwrote in
news:5f******** *************** ***********@b1g 2000hsg.googleg roups.com
:
I really need the Replication/synchronization feature so that
may rule out Access 2007.
It doesn't. As Tony says in reply to this comment, if you use an
MDB, A2K7 provides the same replication functionality as A2K3.

However, there have been signficant bugs in A2K7 in regard to
synchronization -- the original release had a bug that caused the
DAO Synchronize method to fail (though the corresponding JRO command
worked), which was patched first with a hotfix, and later in SR1,
and I'm currently corresponding with a user in the replication
newsgroup who is having problems in with propagation of certain
kinds of design changes from the Design Master, and the problem
occurs only in A2K7.

So, despite the fact that A2K7 still supports Jet replication in the
MDB format, you might want to be cautious in choosing it.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Aug 30 '08 #9
Sky
"Don" <do******@gmail .comwrote in message
news:5f******** *************** ***********@b1g 2000hsg.googleg roups.com...
I've continued to use Access 97 all these years because (1) it does
everything I need quickly and (2) most of what I've read online
indicates that it's still the most bug-free version of Access. But
now that Vista is gradually becoming the only Windows choice and Vista
doesn't exactly "cooperate" with Access 97, I'm afraid it may be time
to take the leap.

I haven't had any experience with later versions of Access so I'm
seeking recommendations .

* Which version of Access is the most stable/bug-free? 2000? 2002?
2003? I really need the Replication/synchronization feature so that
may rule out Access 2007.

* Depending on the version I upgrade to, is there a good soure (onlne
or otherwise) that helps with the transition and learning about the
new features? I have some pretty involved projects with lots of VBA.

Many thanks for any & all suggestions & input...

--Don
I agree that Access 2003 works well after service packs.

As I recall, my biggest conversion issue from Access 97 was dealing with the
new menu and toolbar coding, which changed quite a bit using CommandBar
objects. (Unfortunately menu/ribbon coding changes even more in Access
2007!)

Also Jet 4 uses Windows language-dependent sorting versus Jet 3 ASCII
sorting in queries, which affects any C++ or other code that depends on
sorting.

- Steve

Sep 4 '08 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2339
by: BDR | last post by:
Questions for anyone with experience on this topic... Sit: We're running a standalone server with applications/db's written around 3.23.41. Linux R/H 7.2 with updates. This is an Apache production server (currently in operation w/12 co domains) and we're about to launch new apps using Mysql now that the s/w is complete. Before we do this, there is a lingering q of whether or not to take advantage of a 4.x upgrade at this time, before...
3
1461
by: elaine morgan | last post by:
I have a Microsoft Office Professional & Bookshelf for Windows 95 CD. (version 7.0) This version of Office Pro includes version 7.0 of Access95. Pre installed on my new computer is, Microsoft Office Basic Edition 2003 (s55-00033) MS Office Basic 2003 does not include MS Access. Can I install Access 95 from my Office Pro95 CD to my new computer and then upgrade to Access 2003? Thanks
6
3669
by: Terry Bell | last post by:
We've had a very large A97 app running fine for the last seven years. I've just converted to SQL Server backend, which is being tested, but meanwhile the JET based version, running under terminal server, has suddenly started running very slowly. The network engineer has thrown up his hands and said "It's Access 97". I've checked out lots of things including the Oplocks setting and other stuff from this NG, and I think I've done everything...
47
4537
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small company and this is a big decision for us(!) It's not just the money it's committing to an new version of Access!
6
2079
by: Joseph Geretz | last post by:
I recently upgraded my server to Windows 2003. The first thing I noticed is that my sample WebService pages no longer worked. The Invoke test button is missing. This is addresed by the following KB article: Microsoft Knowledge Base Article - 819267 INFO: HTTP GET and HTTP POST Are Disabled by Default http://support.microsoft.com/default.aspx?scid=kb;en-us;819267 The article advises that a new block be inserted into Web.config (or into
2
8471
by: KR | last post by:
Hi, We are running a test upgrade form sql 2000 standard edition to sql 2005 developer edition. Followed through all the steps and specified the account(SA priveleges and currently used by the 2000 version) and is the local admin on the box for the services and the setup seemed to move fine, except for when it got to the point of installing database services - This is the error message that I got: MSSQLServer could not be started. ...
10
1600
by: Don Leverton | last post by:
I've been away from this newsgroup for quite some time, as my job had changed to the point where I wasn't using Access much anymore. When I left, most of you hated A2K ... and Access 2003 was still pretty new. My experience has been that A97 can do almost anything that I've ever wanted to do, and there is TONS of on-line code samples and support for A97. Now that I'm "back" into using Access more in my job again ... what am I missing...
6
1807
by: ARC | last post by:
I'm almost ready to build an upgrade routine for a commercial app that will need to import data from an existing Access 97 back-end database to an Access 2007 back-end blank database. Ideally, it would be nice to have the program detect, on first launch, whether the back end database is blank, and ask the user if they want to begin a new database (putting them into the blank one), or import data from the previous version (the access 97...
13
2533
by: JakeD | last post by:
SInce about 1996, I have been happily using MS Access for Windows 95, but would now like to upgrade to a recent version. If I get a Windows XP version, will I be able to import all my Access 95 files without problems? Alternatively, should I continue applying the "if it ain't broke, don't fix it" approach, and keep on using Access for Win 95? Thank you for any advice.
0
8886
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9256
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9168
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9105
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8091
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6010
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4509
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4780
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2632
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.