97 Access Database to Office 2003

[buz]

I have a database that was built using Office 97 version and would
like to update a more current platform. This program runs on a server
and the enduser runs the program from thier desktop. Windows NT
setup. When updating the end users with Office 2003 and they
connected to the server database...many errors occurred. I reverted
them back to the 97 version and everything is fine.

What are some of the things that I would need to look at to upgrade
the database to a newer Office platform? Currently, the database
works fine but I think it would perform better on the new platform.

Any help on this would be great.

[Larry Linson]

"buz" <in*************@hotmail.comwrote

What are some of the things that I would need to look at to upgrade
the database to a newer Office platform? Currently, the database
works fine but I think it would perform better on the new platform.

What gave you the idea that it "would perform better" on the new platform?

A cardinal rule for experienced developers is "Don't fix what ain't broke"
and a corollary, "Don't dink with working code."

For your information, Access 97 with its two Service Releases, is generally
acknowledged to be (at least arguably) the best-ever release of Access,
solid and stable.

But, if you are Hell-bent on trying to prove that "newer is better",
searching the newsgroup archives would be a good start, or using your
favorite search engine, and, especially, visiting MVP Allen Browne's site
(the link to which you can find in the Resource Links at my SharePoint site,
http://sp.ntpcug.org/accesssig/default.aspx, where he lists known bugs.

To get help here, you'll do much better if you can identify a specific
problem and give us reasonable details in a precise and concise question.
For other good suggestions on effective use of newsgroups, see the FAQ at
http://www.mvps.org/access/netiquette.htm.

Larry Linson
Microsoft Office Access mVP

[lyle]

On Mar 7, 1:41 pm, buz <[e-mail]:

What are some of the things that I would need to look at to upgrade
the database to a newer Office platform? Currently, the database
works fine but I think it would perform better on the new platform.

Often we find that that new stripper isn't nearly as much fun as our
old regular, but not before we waste money and time, and experience
disappointment.