Access97 to Access 2003 or Access 2007

[buckeroo]

We are currently using Access97 for many different databases in our office
and are considering an upgrade to Access 2003 or Access 2007.

Does anyone know what chance I have of having Access97 forms, reports, and
associated programming convert to Access 2003 or Access 2007?

How buggy is Access 2007? If we are planning to do an update in the next
month or so are we better off going with Access 2003?

Do Access 2003 and Access 2007 have any advantages over each other (or
compared to Access97) with handling larger databases?

Thank you.

 

[John Spencer]

ONE PERSON'S Opinion

If you can make an MDE out of your Access 97 database, it will usually
convert up to 2000 without problems.

I've heard it said, that it is best to convert your database to 2000 and
then if you need to convert that to 2003. (You can do both with a 2003
version of Access).

Since Access 2007 has not yet been released, I'm not sure how buggy it is.
I do know that it has undergone a lot of testing.

Versions of Access later than 97 can handle larger databases (2 gigs vs 1
gig). However, if you are getting that big, you might want to consider
looking at a more powerful database engine than JET (Access "Native" engine)
and use MS SQL or some other SQL engine.

Access 2007 does have some advantages (new features) over previous versions.

 

[JimS]

ONE OTHER PERSON'S Opinion:

I've been using Access 2007 for a couple months. I've been using Access
2003 for a couple of years. I use Access 97 sporadically to support clients.

Access 2007 is an incremental improvement over 2003. Reporting is
smoother. Forms are prettier. Functionality is only marginally changed. I'd
let the hard-core folks yank the bugs outa 2007 beta and use 2003 for a few
more months before upgrading. It doesn't buy you enough to be worth using a
bet as a mission-critical tool...