Are there any issues when converting an Access97 to Access2002.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Are there any problems converting an Access 97 database to Access 2002 in a
multiuser environment? Doing a corporate wide migration and would like to
know if there have been any problems and/or bugs.
 
Tyryss said:
Are there any problems converting an Access 97 database to Access
2002 in a multiuser environment? Doing a corporate wide migration
and would like to know if there have been any problems and/or bugs.
Click to expand...

Note: not all VBA code may convert. Other than that, I understand it
goes smoothly.
 
Changes in Use of DISTINCTROW in Microsoft Access 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;207761

SQL Server connections are a bit different, and we still have
unexplained speed differences in a Novell environment. Parameter
queries are a bit less forgiving of data type conversions, and
runtime errors which give a meaningful message in A97, and crash
A2K, sometimes give meaningless messages in A2K. In an MDB,
Msgbox refers to VBA.Msgbox which is slightly different to
the Access Msgbox you got in A97, and still get from an A2K2
MDE. Using err.raise, you must use explicit calls to MsgBox in
an MDE, because the default Access error handler will replace
err.Description. DAO initialisation at startup is different,
which may affect you if you are using WorkGroup security.
Jet security will affect you if the registry setting are applied.
Record-level locking can affect lock-unlock behaviour.
A2K2 is possibly even more susceptible to network flaws than
A97: your network should be fully patched before doing a corporate
-wide Access update.

Also, as documented elsewhere, no module-level workgroup
security, you can't share a database if you wish to add or
modify a form or report, and new features in general should
be avoided.

(david)
 
Tyryss said:
Are there any problems converting an Access 97 database to Access 2002 in a
multiuser environment? Doing a corporate wide migration and would like to
know if there have been any problems and/or bugs.
Click to expand...

Also see Access 2.0 and Access 97 to Access 2000/2002 conversion
problems
http://www.granite.ab.ca/access/conversionproblems.htm

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
 
There is no conversion involved in that scenario, as Access 2003 does not
introduce any new file format.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access97 conversion issues 10
access97 to 2002 search button conversion error 1
Error Converting Access97 DB to Access2002 DB 3
Converted Access97 dbs to Access2003dbs ? 2
Converter Access2.0 to Access2002 0
Access97 to Access2002(XP) 2
How can I convert ms access2000 files back to ms access97 files ? 1
Converting Access 97 to Acees 2003 & get conversion Errors 1

Back
Top