Should I convert from 97 to 03

[Jeff Klein]

I have an application created in access 97 that occationally gets errors
that exit access. i.e. "... shut down by Windows. Sorry for the
inconvenience." I can not figure out what is causing the error. I thought
if I upgraded to 2003 that the error would stop. After reading the message
boards it looks like versions after 97 are problem ridden. Since the
expense of 2003 for 5 machines is a chunk on change and the potential for
more problems appears to exist maybe the conversion is not a good idea. Any
thoughts, ideas or input would be greatly appreciated. thank you

 

[RobFMS]

If the 97 version works for your group of people, then stay at 97.
What I may recommend is creating a new .MDB and import all the objects from
the old DB to the new DB. The old DB might be running into some corruption
issues.

Do you practice good backup policies??

Still today, I support and maintain applications in Access 97. For one
reason or another, the client did not feel the need (or want) to upgrade.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Allen Browne]

Hi Jeff

Updating probably won't solve these crashes.

Under what circumstances are you experiencing crashes? If it happens when
you are making changes to the database design (i.e. writing code, designing
forms, ...), IME you can configure A2003 so that it is more stable than A97
for development work. If you are not making design changes, you should be
able to run for months, probably years without seeing a crash/corruption in
an environment that has a stable network, stable power, and stable users.

For general suggestions on avoiding corruption, see:
Preventing Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-25.html

For suggestions on how to go about the converion process, see:
Converting from Access 97 to 2000, 2002 or 2003
at:
http://members.iinet.net.au/~allenbrowne/ser-48.html